OraFAQ Forum: Server Administration » Help:: ORA-6571 dbms

Home » RDBMS Server » Server Administration » Help:: ORA-6571 dbms_sql Dynamic sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	HELP rename table
Next Topic:	Help with renameing tables from plsql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 20:25:57 CST 2025