Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function returns error ORA 06571.
Message
 
 
To
13/10/2000 05:40:43
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00428405
Message ID:
00429056
Views:
17
Thanks you for the follow up solution. Sorry I could not have been more helpful.

>My friend explain, what happen:
>
>If I have function, which makes Inserts, Updates or Deletes on MyTable, I cannot call this function with 'select package.MyFunction() from dual', because, same call can be 'select package.MyFunction() from MyTable' too, and Oracle doesn't know (if function modified MyTable), what return.
>
>It works, if is function calling from PL/SQL:
>declare
> promX NUMBER;
>begin
> promX := package.MyFunction();
>end;
>/
>
>Pavel
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform