RE: How to call Oracle Stored procedure through perl ?

[stanley g martin]

Here is what I've used for a stored procedure called TABLE_TRUNCATE.
Without proper permissions you cannot truncate a table in your own
schema in Oracle, so someone wrote this procedure to accomplish this.

$sth = $dbh->prepare(q{
                  BEGIN
                    TABLE_TRUNCATE('SLA_BPR',
'W_BPR_DSSMETA_JOB_STAT_SUMM');
                  END;
         }) or die $dbh->errstr;;
$sth->execute or die $dbh->errstr;

What's in the parenthesis are parameters to the SP, so they would mean
nothing to you, but this is just an example.

Stanley G. Martin
Midwest Consulting Group
Sprint Finance Reengineering
(816) 889-8156
[EMAIL PROTECTED]

-----Original Message-----
From: ravindra.gadge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 5:24 AM
To: perl-win32-users
Cc: ravindra.gadge
Subject: How to call Oracle Stored procedure through perl ?

Hi All,

        I am developing an Web-Based Information Kiosk. I want to create
one web page dynamically depending on the user's input. My client has
given me one Oracle stored Procedure which has got one in parameter, few
in-out parameter & few out parameters. I want to display values returned
by that Oracle stored procedure on the dynamically created user specific
web page.
        I want to know how to call that Oracle Stored procedure through
perl-CGI.

Thanks & regards,
Ravi.



---
You are currently subscribed to perl-win32-users as:
[EMAIL PROTECTED]
To unsubscribe, forward this message to
         [EMAIL PROTECTED]
For non-automated Mailing List support, send email to 
         [EMAIL PROTECTED]