How to install demo packages

[rcoyle]

I have installed the latest version of DOA on my pc. I want to install the deptapi.pck file but cannot find instructions on how to do this. Can someone tell me how to install the onto my oracle server. I looks like it is to be loaded via SQL plus, but I have never done this before.

 

[rcoyle]

I tried logging into SQL Plus with scott and tiger. Then I tried get DeptAPI.pck which parsed the code and then I typed a "/" without the quotes. I received the message "Package created with compilation errors."

 

[Marco Kalter]

Do the dept and emp tables exist in scott's schema? If not, run demobld.sql (from oracle_home\sqlplus\demo).

If this doesn't help type "show errors" after compiling the package with errors.

------------------
Marco Kalter
Allround Automations