Hi All,
I created a stored procedure having Blob datatype as an input parameter.
Ex: CREATE OR REPLACE procedure myproc(name in varchar2, blob_data in blob.
I am trying to call this procedure in Mercator using DBLOOKUP function with call syntax, but I am getting error as datatype of parameter is invalid.
Can anyone help me how to call the procedure having Blob as datatypes using DBLOOKUP function.
I am sucessfull using Type Tree for the stored procedure, but I want to get this sucessfull using DBLOOKUP function
or help me how to execute the above procedure on sqlplus window.
Thanks in advance.
Syam.
I created a stored procedure having Blob datatype as an input parameter.
Ex: CREATE OR REPLACE procedure myproc(name in varchar2, blob_data in blob.
I am trying to call this procedure in Mercator using DBLOOKUP function with call syntax, but I am getting error as datatype of parameter is invalid.
Can anyone help me how to call the procedure having Blob as datatypes using DBLOOKUP function.
I am sucessfull using Type Tree for the stored procedure, but I want to get this sucessfull using DBLOOKUP function
or help me how to execute the above procedure on sqlplus window.
Thanks in advance.
Syam.