Hi, Thanks for the info. But i have a restriction that i can't create procedures on the database...
Thank you Nanditha --- David Kirol <[EMAIL PROTECTED]> wrote: > Hi, > You can call an oracle stored proc by wrapping your > call in a begin .. end > block > > $sqlquery = " BEGIN > ? := your.stored.proc(?, ?); > END"; > then prepare, bind and execute. You can see a simple > example at > http://geocities.com/k2001evad/Dave9.txt > Depending on the type of object you return, however, > you may want to create > another stored proc or function to do the 'Hard > Work' (of retrieving the > column you are interested in) and on the server > using DBI to fetch it. If > you review the link above and can give me that kind > of detail about your > task I would be glad to lend a hand. > David > > -----Original Message----- > From: Nanditha Gade [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 12, 2002 11:23 AM > To: [EMAIL PROTECTED] > Subject: calling oracle stored procedures using DBI > - URGENT > > > Hi, > I have a stored procedure which returns an Oracle > OBJECT. This object contains a list of objects, > which > inturn contain the table. I would like to read a > column from this table. > > I am new to perl DBI. Can some one tell me if this > is > possible. If yes, any pointers would be great. > > > ps: Can you reply to me directly as i am not in the > list. how do i subscribe to the list? > > Thank you > Nanditha Gade > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
