Usage of jc_insert

Hi again,





Trying to get the insert working using jc_insert. My SQL statement is of the format





"SELECT jc_insert('<structure>', 'JChemTest', null, 'true', 'false', null) FROM DUAL"


(I removed the structure and replaced with <structure> to improve readability).





I get the error - 'unsupported column datatype' which is coming from the Oracle .NET data provider. I assume this is because it doesn't like the type of the return value. How can I call this function using SQL?





Cheers





Paul

If you need to insert just one single structure, create a stored procedure which returns a number. Something like:

Code:

create procedure myinsert(in params..., cdid out number) as cdidarr cd_id_array; begin cdidarr := jc_insert('<structure>', 'JChemTest', null, 'true', 'false', null); cdid := cdidarr(1); end;

If you need to insert many structures at once and retrieve an array of cd_ids, you probably need the OraDirect .NET Oracle data provider from Core Lab (http://www.crlab.com) which seems to supports VARRAYs.





Cheers


Peter

Thanks Peter,





That got it working





Cheers





Paul