I have seen similar problem in a different context.
I believe if you edit the DataObject and look at the parameters, you will
see <Unknown> in the Parameter Type selection list. If you change them to
<In> and <Out> accordingly, that should solve the problem. If you have too
many dataObjects, you may want to open the .sdo files without asking ND and
do a search and replace.
Aby
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 09, 1999 7:36 AM
> To: [EMAIL PROTECTED]
> Subject: [ND] Calling Sybase Store Procedure in ND4.1.3
>
> We are in the process of migrating a ND3 application to ND4.
> When I make a call to a store procedure I get the following error.
> 'unknown store procedure parameter mode 4'
> '..setProcedureOutput: There is a mismatch between the parameter schema
> and actual output'
> 'Schema(?)= 0,Actual=0'
>
> The procedure has two input parameters and one output parameters
> CREATE PROC proc_nextnumber( @tblName varchar(30),
> @fldName varchar(30),
> @nextNum int output).
>
>
> We pass the two input parameters to this procedure as follows
> '// Get handle to stored procedure and clear last used values.
> CSpProcedure stpNextNumber = (CSpProcedure)CSpider.getDataObject(
> "dospNextNumber" );
> stpNextNumber.clearAllValues();
>
> // setup the parameters
> stpNextNumber.setValue("Parameter__tblName", new CSpString(tableName));
> stpNextNumber.setValue("Parameter__fldName", new CSpString(columnName));
>
> // Execute and check return code.
> stpNextNumber.execute();
>
> (tablename and column are two string passed to this funtion "address",
> "address_id")
>
> Any ideas would be appreciated
> Thanks,
> Pat
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
