Re: calling stored function from sql

You can not use functions to write to Tables. You will need to convert it to a Procedure. This should be fairly easy - the only difference being is there is no return value.

HTH, David Archer

In article <7pguhv$pae$1_at_nnrp1.deja.com>,   igor_at_easynet.co.uk wrote:
> Hi folks,
>
> I've got a stored PL/SQL function which writes to multiple tables. Can
> I call it from SQL? All the documentation I've found suggests that I
> can't (unless wrapping it in a stored package and not defining PRAGMA
> RESTRICT_REFERENCES would work - but I'd guess that may be fatally
> dim). If I can't, what's the mistake I'm making in my basic approach?
>
> I'd have thought it would be common to want to use PL/SQL stored
> functions to pass a load of values from an application program into
the
> database and not worry about table structures etc. Am I on the wrong
> track here?
>
> Bit of background: I'm reasonably experienced with databases (I've
used
> faircom, access, foxpro, mySQL), but I'm new with this project to
> Oracle development.
>
> Any clues greatly appreciated.
> Thanks,
> Igor.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 10:18:40 CDT