Hi,

I'm experimenting stored procedure on OpeEdge .

I've successfully compiled and run below stored procedures without any error in sqlexp but I've unable to get any result .

I've tried both with OpenEdge 10.1a and OpenEdge 10.1b evaluation

@echo true;

@autocommit true;

DROP PROCEDURE customers_proc;

CREATE PROCEDURE customers_proc()

RESULT (

name CHARACTER(100)

)

BEGIN

String sname = "";

SQLCursor custcursor = new SQLCursor ( "select name from pub.customer") ;

custcursor.open ();

custcursor.fetch ();

while (custcursor.found())

{

sname = (String) custcursor.getValue(1, CHARACTER);

SQLResultSet.set (1, sname);

SQLResultSet.insert ();

custcursor.fetch();

}

custcursor.close ();

END;