Re: Stored procs that returns resultsets to perl

2003-11-28 Thread Martin Busik
Hi, > I actually mean results sets, multiple rows returned. > I have had problems with the exact syntax against > ms sql server all the time, and was worried it is not possible to do it. > I was able to find more references to Oracle by googling etc but thay > syntax didn't seem to work for me as

Re: Stored procs that returns resultsets to perl

2003-11-27 Thread Martin Busik
Hi, > Is there anybody out there that can > give an example of calling a stored > proc from within perl and then fetch > the result set returned by the proc? Do you mean "result value" (scalar value in terms of perl) or "result set" (more than one row)? If you mean "result value" then you can use

RE: Stored Procs

2002-08-20 Thread Fox, Michael
oduce your coredump Michael Fox -Original Message- From: Rozengurtel, Daniel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:02 AM To: 'Fox, Michael'; '[EMAIL PROTECTED]' Subject: RE: Stored Procs I did that Mike but I get a "Segmentation

RE: Stored Procs

2002-08-20 Thread Rozengurtel, Daniel
I did that Mike but I get a "Segmentation Fault(coredump)" any ideas? Thanx > -Original Message- > From: Fox, Michael [SMTP:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 7:34 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Stored Procs >

RE: Stored Procs

2002-08-19 Thread Fox, Michael
Sent: Tuesday, August 20, 2002 7:05 AM To: 'Fox, Michael'; '[EMAIL PROTECTED]' Subject: RE: Stored Procs Hello everybody, I was wondering if I can get anybody's help about my error that I get while running the following code: I u

RE: Stored Procs

2002-08-19 Thread Rozengurtel, Daniel
n 4: PLS-00306: wrong number or types of arguments in call to 'OPEN_INCOME_EVENTS' ORA-06550: line 3, column 4: PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at package_call.pl line 116. Thanx to all of you . daniel > -Original Message- > From: Fox, Michael [SMTP