PB version 7.0, is a 64 - bit operating system, install is oracle11,
Database connection is successful, when reading data suggest the Select error: This cursor -based stored procedure has no columns. Check the
PBDBMS DbParm and the procedure syntax.
Please have a look at what is reason,

CodePudding user response:

Permission problems

Ls_User ls_SQLStatement="the ALTER USER" + + "DEFAULT roles SOME_ROLE"
The execute immediate: ls_SQLStatement using SQLCA;

Ls_User refers to connect you with the oracle database on a user name

CodePudding user response:

http://www.sybasebuilder.info/how-can-i-run-alter-statement-in-pb-6-5-1-with-oracle-8i