I wrote a class:
public void run()
{
Connection con;
Statement stat;
ResultSet result;
SqlStatementExecutePermission _perm;
str sqlStr,r1;
;
con = new Connection();
sqlStr = strfmt(‘exec GetAccountNumber’);
stat = con.createStatement();
_perm = new SqlStatementExecutePermission(sqlstr);
_perm.assert();
result = stat.executeQuery(sqlstr);
while(result.next())
{
info(result.getString(1));
}
CodeAccessPermission::revertAssert();
}
and it errors with:
Cannot select a record in (). The SQL database has issued an error.
The stored proc in ver simple for example:
ALTER
PROCEDURE GetAccountNumber
as
SET
NOCOUNT ON
SELECT * FROM CUSTTABLE NOCOUNT OFF
GO
Please avdise.
Thanks!!