RE: problem calling oracle stored proc
RE: problem calling oracle stored proc
- Subject: RE: problem calling oracle stored proc
- From: "Lakeman, Brian" <email@hidden>
- Date: Mon, 24 Feb 2003 14:52:13 -0600
- Thread-topic: problem calling oracle stored proc
I discovered what the problem was, the name of the parameter in the model must match the name in store procedure. I changed it to AggTransmission_id and all is well.
-Brian
-----Original Message-----
From: Lakeman, Brian
Sent: Monday, February 24, 2003 10:34 AM
To: email@hidden
Subject: problem calling oracle stored proc
With WO 4.5.1 I can call a stored procedure without any parameters just fine, but I can't seem to call it now that I've added a parameter.
The stored procedure is called run, and it's in a package called aggregate:
PROCEDURE Run(AggTransmission_id IN NUMBER) IS
Here's the error that I get:
Feb 24 15:06:08 AggregateApp[1664] *** <OracleChannel: 0x23a2b488> executeStoredProcedure:{
arguments = (
{
allowsNull = Y;
columnName = transmission_id;
externalType = NUMBER;
internalInfo = {_nameInObjectStore = ""; };
name = transmission_id;
parameterDirection = 1;
valueClassName = NSNumber;
valueType = i;
}
);
externalName = aggregate.run;
name = aggregate;
userInfo = {modificationDate = "2000-09-13 14:45:26 +0000"; };
} withValues:{transmission_id = 2626; }
Feb 24 15:06:08 AggregateApp[1664] >>> Begin Transaction
Feb 24 15:06:08 AggregateApp[1664] === Begin Internal Transaction
Feb 24 15:06:08 AggregateApp[1664] *** [<OracleChannel: 0x23a2b488> evaluateExpression: <OracleSQLExpression: "begin aggregate.run ( transmission_id => :transmission_id ); end;" withBindings:{transmission_id = 2626; }>] requiresParse:YES
Feb 24 15:06:08 AggregateApp[1664] === Rollback Internal Transaction
Feb 24 15:06:08 AggregateApp[1664] ^^^ Rollback Transaction
Feb 24 15:06:08 AggregateApp[1664] *** Uncaught exception: <EOGeneralAdaptorException> ORA-06550: line , column :
Thanks
-Brian
email@hidden
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.