how to debug an oracle package with sqlplus?

Answer 1

You usually use tools such SQLnavigator to do this. Oracle has not provided any native tools for this.

Only way is execute the statement in the prcedure on sql prompt one by one. you can declaire variable and use it.

Answer 2

In Oracle Database 10g, several enhancements are available in the PL/SQL language. In this overview section, you cover the following topics:
Bulk Binding Enhancements
Oracle Database 10g extends the enhancements that were introduced in Oracle9i in the area of bulk binding. The SAVE EXCEPTIONS syntax was introduced in Oracle9i to capture exceptions while bulk inserting (deleting or updating) rows. Although this feature enables the data manipulation language (DML) to continue (saving any exceptions in the SQL%BULK_EXCEPTIONS collection), the performance of the operation is greatly affected. In a scenario in which the collection being processed is sparse due to the application logic involved, this would be an unnecessary overhead. In Oracle Database 10g, you can overcome these issues with the new INDICES OF and VALUES OF features.
Debugging PL/SQL with JDeveloper
Starting with version 9.0.3, JDeveloper supports PL/SQL debugging. This is achieved with the Java Debugging Wire Protocol (JDWP). With Oracle9i, release 2 (and later versions), the debugger uses the industry standard, whereas for earlier releases (Oracle8i and Oracle9i, release 1), the DBMS_DEBUG package is used. The debugging UI gives you the ability to single step, step into, and step over PL/SQL objects as well as the ability to set PL/SQL expressions in the Watch and Inspector windows, set conditional breakpoints, and view collection data.
PL/SQL Compiler Enhancements
The PL/SQL compiler is substantially improved in Oracle Database 10g. The back-end code generator is reengineered. Also, the new parameter PLSQL_OPTIMIZE_LEVEL has been introduced to speed up the execution of PL/SQL code. This is in addition to native compilation (which has been available since Oracle9i). The PLSQL_OPTIMIZE_LEVEL parameter default is currently "2".

Answer 3

Better use DBMS_OUTPUT.PUT_LINE() IN SOME PLACES

OR

insert it into some temporar tables and check it.

The below are some examples which u have to use in some places within Package Procedures or Functions.

dbms_output.put_line(1);
insert into temp values(1);

Download Pl/Sql Developer and perform debugging easily.

Answer 4

For the best answers, search on this site https://shorturl.im/aydmQ

During installation oracles make a default database, select its configuration and simply enable scott account in it. Else you can use sysman as a user name (sysman is admin usename i don't know its password , you better search it).