Home » SQL & PL/SQL » SQL & PL/SQL » procedures
procedures [message #201832] Tue, 07 November 2006 00:41 Go to next message
Messages: 95
Registered: July 2003
Hello folks and thanks for any help.
I do not know what I miss in the code bellow which goal is to draw a line, because I receive the following message error:
"Avertissement : Procádure crée avec erreurs de compilation."
"Warning: Procedure created with compilation error"

What should be added to resoulve the problem?

set serveroutput on
create or replace procedure proc_trait (taille_trait integer:=30 ) IS
i integer; trait varchar2(200):='';
for i in 1 .. taille_trait loop
trait:=concat (trait,'=');
End loop;

Re: procedures [message #201835 is a reply to message #201832] Tue, 07 November 2006 00:49 Go to previous messageGo to next message
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

 get rid of the Declare.you don't need to inclued it in a stored procedure.

Re: procedures [message #201849 is a reply to message #201835] Tue, 07 November 2006 01:18 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Next time type
show errors
if you get the "Warning: Procedure created with compilation error" message again.
Previous Topic: Copy data from table 1A,1B to table 2A,2B & Update table 1A,1B
Next Topic: Output in Text File
Goto Forum:

Current Time: Thu Aug 17 18:31:53 CDT 2017

Total time taken to generate the page: 0.12760 seconds