Home » SQL & PL/SQL » SQL & PL/SQL » procedures
procedures [message #201832] Tue, 07 November 2006 00:41 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
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
DECLARE
i integer; trait varchar2(200):='';
BEGIN
for i in 1 .. taille_trait loop
trait:=concat (trait,'=');
End loop;
dbms_output.put_line(trait);
END;
/


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

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



regards,
Re: procedures [message #201849 is a reply to message #201835] Tue, 07 November 2006 01:18 Go to previous message
Frank
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: Fri Dec 09 17:26:44 CST 2016

Total time taken to generate the page: 0.35299 seconds