Home » RDBMS Server » Server Administration » Help:: ORA-6571 dbms_sql Dynamic sql
Help:: ORA-6571 dbms_sql Dynamic sql [message #371029] Mon, 14 August 2000 14:21
shravan
Messages: 13
Registered: March 2000
Junior Member
I have a standalone function, which I call from a select statement like
"Select fn_skill_count, col2,... from dual"

The function itself has dynamic sql (uses dbms_sql) and returns the result of the execution of the dynamic sql.

I don't get any error in oracle 8.1... but the same statement returns an error in Oracle 7.3.

Why is this so.?? Please help

Is it necessary to put the function in a package to avoid the ORA-6571 ERROR. I thought PL/SQL gurantees the purity level of standalone functions, then why is this error occuring.

I did try to put this function in a package with the Pragma Restrict_references(WNDS) with no luck, still getting the error.

ANY CODE IS REALLY APPRECIATED.

Thanks
Shravan
Previous Topic: HELP rename table
Next Topic: Help with renameing tables from plsql
Goto Forum:
  


Current Time: Thu Mar 28 18:03:17 CDT 2024