CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
executer une procedure stockee oracle dans un script perl

 



fireit
New User

Apr 28, 2009, 5:43 AM

Post #1 of 2 (2760 views)
executer une procedure stockee oracle dans un script perl Can't Post

bonjour.
je souhaite executer une procedure stockee oracle dans un script perl.


dans mon code je fais:

system("sqlplus yabre/yabre")

je cherche comment ajouter l'execution de la procedure : execute maproc (execute est une commande qui se lance dans sqlplus.

quelqu'un peut il m'aider?


1arryb
User

Apr 29, 2009, 1:45 PM

Post #2 of 2 (2736 views)
Re: [fireit] executer une procedure stockee oracle dans un script perl [In reply to] Can't Post

Bonjour fireit,

Nous non parlons pas bouquet de Francais ici (switching to English before I embarrass myself), but:

I am not a sqlplus expert. There may be a way to put a sql statement on the command line. I am sure there is a way to have sqlplus execute a sql file. You could write a little script that calls the procedure, save it to a file, and then call sqlplus to execute the file.

Of course, the real way to do this is to open a Perl DBI session and execute the procedure from inside your script.

Ciao,

Larry

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives