Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Will Oracle _ever_ provide a built in SYSTEM command in PL/SQL
In article <7b0f1h$614$1_at_nnrp1.dejanews.com>,
bonanos_at_yahoo.com wrote:
> Hi All
>
> The one major frustration I have with Oracle is its lack of a SYSTEM command.
> Such a function is one of the basics of any language.
>
> Any body else feel that way?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
What is that 'basic part of any language' supposed to do? If it's supposed to execute OS command from PL/SQL, then there are serious problems with the concepts surrounding that command. PL/SQL is not, I say not a general purpose programming language and you don't have a general way to execute a command or API call from PL/SQL. Now, to alleviate your pain, in Oracle8 you have external procedure calls which allow the mapping of C functions into PL/SQL procedures. There was a program, published in Oracle Magazine which solves that exact problem. I would have posted the code here, but I don't want to spoil you a pleasure of reading it.
May the force be with you,
Mladen Gogala
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 11:50:05 CST