Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function returns error ORA 06571.
Message
 
 
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00428405
Message ID:
00429056
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform