PB的版本為7.0,作業系統是64位的,裝的是oracle11,
資料庫連接成功,在讀取資料的時候提示Select error:This cursor based stored procedure has no columns.Check the
PBDBMS DbParm and the procedure syntax.
請幫忙看一下是什么原因。
uj5u.com熱心網友回復:
權限問題ls_SQLStatement = "ALTER USER " + ls_User + " DEFAULT ROLE SOME_ROLE"
execute immediate :ls_SQLStatement using SQLCA;
ls_User 指的是你連接oracle資料庫時用得用戶名
uj5u.com熱心網友回復:
http://www.sybasebuilder.info/how-can-i-run-alter-statement-in-pb-6-5-1-with-oracle-8i轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/78038.html
標籤:數據庫相關
下一篇:如何發布用PB9.0制作的軟體?
