euRE: [PHP-DB] Passing NULL to OCIBindByName()

I've tried unsuccessfully to bind to a stored procedure with an output parameter whose type is a user-defined record type. For example (taken from a package): TYPE CustAcctRec IS RECORD( custID NUMBER, acctID NUMBER ); PROCEDURE findAcct( custID IN NUMBER, custAcct OUT CustAcctRec ) IS BEGIN ... END; Is it possible to do so? I also have not been able to get a function to execute. I've tried $stmt = OCIParse( $conn, "begin retval = func(); end;" ); and $stmt = OCIParse( $conn, "declare retval NUMBER; begin retval = func(); end;" ); Questions: - Do you need to perform a bind? If so, how? - If not, how do get the return value? -----Original Message----- From: thies@digicol.de [mailto:thies@digicol.de] Sent: Monday, June 19, 2000 9:52 AM To: Fred M. Bulah Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Passing NULL to OCIBindByName() On Mon, Jun 19, 2000 at 06:51:53AM -0400, Fred M. Bulah wrote: .. > > FB: > 1. ROWTYPE is a PL/SQL directive that defines a record with the same columns > as the given table. In the above example, customer_rec is defined as a > record with the same structure (columns) as the table Customer. Further, > you can define your own types using the TYPE directive. Is it possible to > bind to these types when they are declared as output parameters. > > 2. How do you bind (via OCIBindByName) to the function return values in both > of the cases you cite ("begin retval = funcname(); end" and "select > funcname() from dual")? Should the first be > $stmt = OCIParse( $conn, "begin :retval = funcname(); end" ); > OCIBindByName( $stmt, ":retval", &$retval, 32 ); in the select case there's no need to bind (obviously). the other case would work as you described. > > > > > > - How do you execute a stored procedure that executes a select that has an > > output > > parameter declared as a table ROWTYPE or user-defined type ? The issue > here > > is the > > binding to the output parameter. > > i don't know ROWTYPE stuff at all - maybe send me a *TINY* > (10 lines php + 10 lines sql) testcase so i can see what > you're talking about. fred, i don't know rowtype types, and i won't answer any more questions on this issue unless somebody sends me a (i've said the following too many times - maybe i get heart this time;) short, self-containig test case that lets me "play around", understand and reproduce. right now i'd say that ROWTYPE might not be supported in the oracle-oci8 interface, but i might be wrong. tc > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > Hammerbrookstr. 93 20097 Hamburg / Germany > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net