I've tried this code:
OdbcConnection connection;
Statement stmt;
LoginProperty LP = new LoginProperty();
ResultSet resultSet;
str sqlS;
int i;
;
LP.setServer("TOHA");
LP.setDSN("TestDB");
LP.setUsername("test");
LP.setPassword("test");
connection = new OdbcConnection(LP);
stmt = connection.createStatement();
sqlS = 'execute sys.My_TESTPackage.GetClientsProc(\'test\');';
resultSet = stmt.executeQuery(sqlS);
i = stmt.getLastError();
while (resultSet.next())
{
info (resultSet.getString(2));
}
System generates "[Oracle][ODBC]Syntax error or access violation"
error message.
User "test" has rights to execute this package.
sqlplus executes this query without any problem.
--
WBR
toha mailto:[EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
