stored procedures in perl?? howww??? [Archive]

View Full Version : stored procedures in perl?? howww???

shuchi

01-17-03, 05:34

hi every1
ive come with a problem yet again! how do i create/call stored procedures from within a perl scrip..using isql syntax.
thnx in advance fr ne help....pleezzz post ur replies asap..!am in a bigg hurry!
:)
shuchi

mpeppler

01-19-03, 15:39

It would help if you mentioned what database server you are using, and what you are trying to achieve.

Michael

shuchi

01-19-03, 23:57

thank u... i managed to solve that problem.
Now i need to know how to make calls to batch files from inside a perl script.
i am using a sybase server.

mpeppler

01-20-03, 13:38

If you are using DBI, then you can simply read the file and submit the commands via prepare/execute in the normal way.
If you simply want to run isql with the batch file then look at the system() function in the perlfunc man page (perldoc perlfunc).

Michael