KUBO Takehiro
6/13/2008 4:04:00 AM
On Thu, Jun 12, 2008 at 7:55 AM, Sri Krishna <schitturi@gmail.com> wrote:
> stmt.c:541:in oci8lib.so: ORA-06550: line 1, column 7: (OCIError)
> PLS-00306: wrong number or types of arguments in call to 'tax'
...
> tax_request_id_out number out
...
> plsql.bind_param(':taxReqIdOut', OCI8::Cursor)
You cannot bind a number argument as OCI8::Cursor.
Oracle doesn't know how to convert implicitly ref cursor
(OCI8::Cursor) to Number.
Bind it as Float or Integer.
plsql.bind_param(':taxReqIdOut', nil, Float)
or
plsql.bind_param(':taxReqIdOut', nil, Integer)
...
plsql.exec
...
tax_request_id = plsql[':taxReqIdOut']