oracle+storedproc
From: arnold (arnold_at_codeworx.net)
Date: 10/28/03
- Next message: ààÎ÷Î÷: "breakpoint hints"
- Previous message: Andre Greyling: "Retrieve an Access AutoInc Primary Key"
- Next in thread: arnold: "Re: oracle+package function"
- Reply: arnold: "Re: oracle+package function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 28 Oct 2003 08:15:04 +0100
I'm trying call an oracle package function
package1
func1(p1 number,p2 number,p3 number) return number
in VC, I call it like this, which works fine:
commandtext="{?=call package1.function(%d,%d,%d)}"
in Delphi, I tried TADOStoredProc
ProcedureName -> package1.func1
4 parameters
0..pdOutput,integer
1..pdInput,integer
2..pdInput,integer
3..pdInput,integer
when I'm trying to open the stored proc, I get an 'Unspecified Error'.
I'm using the Oracle OleDB Provider.
Why doesn't this work? Does anyone have an example?
g
arnold
- Next message: ààÎ÷Î÷: "breakpoint hints"
- Previous message: Andre Greyling: "Retrieve an Access AutoInc Primary Key"
- Next in thread: arnold: "Re: oracle+package function"
- Reply: arnold: "Re: oracle+package function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
