compiled with warnings

[sweetleaf]

Hi there,

When I compile a package I wrote, the oracle compiler is generating the "compiled with warnings" error .. what does that mean?

How can I resolve this?

Thanks,
Mark

 

[sem]

Can you provide exact error code and text? What tool do you use to compile your procedure? Regards, Dima

 

[alexhu]

From the SQLPlus Users Guide;

Shows the compilation errors of a stored procedure (includes stored functions, procedures, and packages). After you use the CREATE command to create a stored procedure, a message is displayed if the stored procedure has any compilation errors. To see the errors, you use SHOW ERRORS

Alex

 

[sweetleaf]

Hi,

I'm using SQL Navigator.
I'd like to compile this in SQL*Plus so that I may use the show err command - but when I try to copy and paste my package code into SQL*Plus, the clipboard is too small and not all the code gets copied over..

Is there a way to directly edit my package code using SQL*Plus?

 

[sem]

You may run your script by @file.

Another way is to type

ed

in sql*plus command prompt.

Paste your code into your editor (Notepad?).
Close it (confirm to save). Regards, Dima

 

[sweetleaf]

Hi,

When I log into SQL*Plus and first type ED
I get "Nothing to Save" from SQL*Plus..

 

[alexhu]

just do a 'select from something' in order to get something in the editor buffer. Then you can do 'ed', delete what is in there and add your code

Alex

 

[did02]

Hi,

In your SQL*Plus, to execute your script, type :

@file_path\file_name

where file_path is the directory where your script is located and file_name its name.

Then, if you always get the msg 'Compiled with error', type:

show errors

Hope it helps U
Rgds,
Did02