RE: [PHP-DB] Oracle stored procedure help...

Well I'm new to this and I was trying to figure out how stored procedures from oracle worked with php... Even though it works now (THANKS A LOT!) I still don't understand it totally... for example I still don't even have a clue as to what OCINewCursor is or why you need you even need it. Does anyone know were I could find a good tutorial or book on how to use oracle's stored procedures in php so I can know what each function in php does? I'd prefer something that doesn't read like stereo instruction! :) Thanks again! Jay Paulson -----Original Message----- From: Thies Arntzen [mailto:thies@digicol.de] Sent: Thursday, September 14, 2000 10:08 AM To: Paulson, Joseph V. "Jay" Cc: 'php-db@lists.php.net' Subject: Re: [PHP-DB] Oracle stored procedure help... > //connect to db > $conn = OCILogon("username","password","db"); > $curs = OCINewCursor($conn); don't need OCINewCursor just do: $stmt = OCIParse($conn,"begin NAC_CONTACT_ADD(:P_RETURN_CODE, :P_RETURN_MSG, :p_acct_no, :p_div, > :p_CDE_ACTION, :p_name, :p_PHONE_NO, :p_PHONE_TYPE, > :p_login_id, null, :p_commit); end;"); declare is not sql - it's sqlplus'es way of creating bind variables. ocibindbyname($stmt,"P_RETURN_CODE",&$P_RETURN_CODE,28); ocibindbyname($stmt,"P_RETURN_MSG",&$P_RETURN_MSG,255); .. rest of the binds ... why would you want to use a cursor when you're expections a NUMBER and VARCHAR2 back? tc