This content has been marked as final. Show 3 replies
there are mistakes, but wouldn't it be better if you try to learn the Oracle Syntax of SQL and pl/sql? The mistakes you make are very basic, and a little more knowledge of pl/sql will solve these errors.
Furthermore you can format the code for a better read for us with
. Your error is in the select .. into, first the columns then the into (see http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/selectinto_statement.htm#i36066) Further, you open the cursor, but you also closes it. What do you need for your output, the caller will get no cursor, because it is closed. Herald ten Dam http://htendam.wordpress.com
I corrected it now in SELECT>
select ISSUERTABLEID,ACQUIRERTABLEID into outissu,outacq ....
and im getting all the columns in cursor and going to use it afterwards like below
oresult oot = odb.ExecuteSQL("Begin CRangeproc(...,:CIssuer,...); End;");
OParameter EmpcurParam = odb.GetParameters().GetParameter("CIssuer") ;
const char *issuid;
OField Enamefld = EmpcurDynaset.GetField("ISSUERTABLEID");
Am i doing in correct way?