Many options should work.
You can create a data object for a stored procedure. To do this after you
select Data Object on the Insert Menu in the studio, on the first page
choose Procedure in the data access type group.
If you create a stored procedure data object access it in Java like this:
CSpProcedure proc = CSpider.getDataObject("storedProcedureDataObjectName");
You can also use execute immediate to use a stored procedure without a data
object:
CSpDataObject.executeImmediate("dataSourceName", "EXECUTE
storedProcedureName('stringParam1', 1234)");
Of course, like any other code, problems can arise with stored procedures,
last week I was getting an error that parameters were not set for a Sybase
stored procedure, even though I had called setValue on the data object for
the parameters. We needed a solution quickly so we changed the procedure in
the database, we removed the arguments and invented some defaults.
Good luck.
Brendan Johnston
TeamND
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 13, 1999 7:18 AM
To: [EMAIL PROTECTED]
Subject: [ND] How do I execute a stored procedure that I
can't see as a Data Object?
I created a Data Source, but the stored procedure does not show up
when I rtyy to
make a Data Object from that Data Source. I've been told
that I can still execute
the proc through java code but I have no idea how. Any
help would be appreciated.
Thanks,
jb
_________________________________________________________________________
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]
_________________________________________________________________________
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]
