AboutSuchitra Joshi Expertise I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.
Experience 10+ years D2K
Awards and Honors OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, Database, PL/SQL
Expert: Suchitra Joshi Date: 6/11/2008 Subject: Calling SQL Stored procedure from PLSQL function
Question Hi Suchitra,
As a follow-up, I could not reply back to the previous thread.
The only option that successfully compile is WNDS; but when i execute SELECT EQDAS_MISC.TEMP_ORACLE_FUNCTION('OADM') FROM dual;
i still get the same error i got first:
ORA-06571: Function TempSQLSP does not guarantee not to update database
Thanks,
Shashi
Answer Hi Shashi,
In that case, I would suggest you write the procedure/function tempsqlsp in oracle instead of sql server. You can reference the tables of sql server using the dblink.
Try this and if this does not work, I am really sorry that I can't help you.
