im trying to handle an custom EXCEPTION in SQLPLUS, i have two stored Procedures, and I have the second stored procedure calling the first one. In the first Stored procedure, i have a CASE thats checking the data_types of the rows in a table, and if the Type IS ...
dropping an unexisting index is OK (just catch the exception and continue) create an index that is failing should continue to create the remaining indexes to th the end My PLSQL script is set serveroutput on; WHENEVER SQLERROR EXIT SQL.SQLCODE; DECLARE index_not_exists EX...
err while trying to retrieve text for error ora-12514 之后我查看环境变量,发现Path里面根本指定的是我现在如图所示Oracle对应的oci.dll(一般而言,会有一个下拉的供你选择,选那个就ok了。。)——即:在你装了多个oracle的情形下,该pl/sql developer指向的是哪个oracle示例要搞清楚! 一定要和环境变量里面对应的O...