calling a stored procedure in oracle from oscript

Ron_Warwick_(sglcadmin22_-_(deleted))

if anybody knows how to call a stored procedure in oracle from oscript then please tell me i need it urgent

eLink User

Message from Hans Stoop <<A HREF="mailto:hstoop@opentext.com">hstoop@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi,

 

You need to do it via a select statement. Something like:

Stored procedure:create or replace package hans_stoop asfunction callreturn varchar2;pragma restrict_references(call,wnds,rnds,wnps,rnps);end hans_stoop;/create or replace package body hans_stoop isfunction callreturn varchar2isbeginreturn 'Hi Hans!';end call;end hans_stoop;/ SQL:select hans_stoop.call from dual

 

Hans Stoop

----------------------
LivelinkUp Europe 2002
Open Text User Conference
Paris, France
April 14-17, 2002

Find out how we're helping five million great minds
work together to improve efficiencies and save money.

http://www.opentext.com/livelinkup/

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Development Discussion
Sent: vrijdag 8 februari 2002 12:04
To: eLink Recipient
Subject: calling a stored procedure in oracle from oscript

 

calling a stored procedure in oracle from oscript

Posted by SglcAdmin22 (Warwick, Ron) on 02/08/2002 06:01 AM

if anybody knows how to call a stored procedure in oracle from oscript then please tell me i need it urgent