Oops. For the record, the procedure name is CREATE_ONE_SCIENTIST_FROM_NED. It matches in the database and in the Direct DBMS call; this was just a typo when I sent the email. The error is not related to this. :)
From: Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 9:18 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Oracle Stored Procedures Hi everyone, I'm trying to use a direct DBMS action to execute Oracle 9i Stored Procedures. The procedure utilizes out parameters to return values to the user. The procedure definition is: create procedure CREATE_ONE_SCIENTIST (pnedid in char, bdate in date, this_scid out char) and it is known to work perfectly if called from sql*net or an Oracle tool. I've read up on the <@BIND> metatag and attempted to follow the instructions in the documentation and on this mailing list, and have been getting some pretty generic error messages telling me that the values are not being bound correctly. Here is my direct DBMS statement: begin CREATE_ONE_SCIENTIST_FROM_NED ( <@bind name=nedid scope="method" bindtype="in" datatype="char" precision="10">, <@bind name=bdate scope="method" bindtype="in" datatype="date">, <@bind name=thisscid scope="method" bindtype="out" datatype="char" precision="10">); <@CRLF> commit; <@CRLF> end; The two input parameters, nedid and bdate, have been previously stored in method variables, and the hope is that the output parameter would be stored in the variable method$thisscid. I should note that this is being executed on the most recent Witango development server on OS X, and the datasource is an Oracle OCI. Thanks for the assistance! Mike PS: I noticed too that when the <@BIND> tag creates the database call, it takes whatever follows the name parameter and just sticks a ":" in front of it. <@bind name="method$bdate"> becomes :"method$bdate" when sent to Oracle; is this correct? I don't know if all of those characters are allowed in Oracle variable names. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
