Ggtcf

How much of data wrangling is a data scientist's job?

What would happen to a modern skyscraper if it rains micro blackholes?

Arrow those variables!

How much RAM could one put in a typical 80386 setup?

Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws)

Do infinite dimensional systems make sense?

Why is consensus so controversial in Britain?

Client team has low performances and low technical skills: we always fix their work and now they stop collaborate with us. How to solve?

dbcc cleantable batch size explanation

Unable to deploy metadata from Partner Developer scratch org because of extra fields

What's that red-plus icon near a text?

Revoked SSL certificate

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Could an aircraft fly or hover using only jets of compressed air?

How do I deal with an unproductive colleague in a small company?

Can a vampire attack twice with their claws using Multiattack?

Replacing matching entries in one column of a file by another column from a different file

Do I have a twin with permutated remainders?

What does "Puller Prush Person" mean?

Does detail obscure or enhance action?

Are astronomers waiting to see something in an image from a gravitational lens that they've already seen in an adjacent image?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

Why is Minecraft giving an OpenGL error?

Why is 150k or 200k jobs considered good when there's 300k+ births a month?

Error creating procedure: declare and end error

Drop a table in a procedurecreate procedure in oracleCreating stored procedure giving errorGrant read access using for loopOracle procedure exception compile errorEncountered the symbol “PROCEDURE” when expecting one of the following:Oracle Stored Procedure Compilation error during alter tableWhy am I encountering the symbol end of file in Oracle?Regarding PLSQLPLS Error: 00103 Encountered the symbol “EXCEPTION”

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'm starting with the procedures and I'm lost with these problems.

I do not understand why I get an error when I add the procedure because I think it's ok and neither does it cause an error in the end.

I attach the code.

Errors:

LINE/COL ERROR

---

10/1 PLS-00103: Encountered the symbol "DECLARE"

16/4 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge

Code:

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
INSERTMOV_COD_BANCO IN NUMBER,
INSERTMOV_COD_SUCUR IN NUMBER,
INSERTMOV_NUM_CTA IN NUMBER,
INSERTMOV_FECHA_MOV IN DATE,
INSERTMOV_TIPO_MOV IN CHAR,
INSERTMOV_IMPORTE IN NUMBER
);

DECLARE
 sql_str VARCHAR2(500):='';

BEGIN
 sql_str:=sql_str||'INSERT INTO MOVIMIENTOS (';
 dbms_output.put_line(sql_str);
END; 
/

oracle stored-procedures plsql

share|improve this question

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  problem with ; before DECLARE. Check techonthenet.com/oracle/procedures.php
  
  – Jahirul Islam Bhuiyan
  Mar 9 at 7:08
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ; is only one problem here. The other one is that DECLARE starts an anonymous block. An anonymous block cannot appear within the declaration section of another block.
  
  – Jeffrey Kemp
  Mar 14 at 3:12
  

  
  
  
  

add a comment | 

0

I'm starting with the procedures and I'm lost with these problems.

I do not understand why I get an error when I add the procedure because I think it's ok and neither does it cause an error in the end.

I attach the code.

Errors:

LINE/COL ERROR

---

10/1 PLS-00103: Encountered the symbol "DECLARE"

16/4 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge

Code:

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
INSERTMOV_COD_BANCO IN NUMBER,
INSERTMOV_COD_SUCUR IN NUMBER,
INSERTMOV_NUM_CTA IN NUMBER,
INSERTMOV_FECHA_MOV IN DATE,
INSERTMOV_TIPO_MOV IN CHAR,
INSERTMOV_IMPORTE IN NUMBER
);

DECLARE
 sql_str VARCHAR2(500):='';

BEGIN
 sql_str:=sql_str||'INSERT INTO MOVIMIENTOS (';
 dbms_output.put_line(sql_str);
END; 
/

oracle stored-procedures plsql

share|improve this question

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  problem with ; before DECLARE. Check techonthenet.com/oracle/procedures.php
  
  – Jahirul Islam Bhuiyan
  Mar 9 at 7:08
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ; is only one problem here. The other one is that DECLARE starts an anonymous block. An anonymous block cannot appear within the declaration section of another block.
  
  – Jeffrey Kemp
  Mar 14 at 3:12
  

  
  
  
  

add a comment | 

I'm starting with the procedures and I'm lost with these problems.

I do not understand why I get an error when I add the procedure because I think it's ok and neither does it cause an error in the end.

I attach the code.

Errors:

LINE/COL ERROR

---

10/1 PLS-00103: Encountered the symbol "DECLARE"

16/4 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge

Code:

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
INSERTMOV_COD_BANCO IN NUMBER,
INSERTMOV_COD_SUCUR IN NUMBER,
INSERTMOV_NUM_CTA IN NUMBER,
INSERTMOV_FECHA_MOV IN DATE,
INSERTMOV_TIPO_MOV IN CHAR,
INSERTMOV_IMPORTE IN NUMBER
);

DECLARE
 sql_str VARCHAR2(500):='';

BEGIN
 sql_str:=sql_str||'INSERT INTO MOVIMIENTOS (';
 dbms_output.put_line(sql_str);
END; 
/

oracle stored-procedures plsql

share|improve this question

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
INSERTMOV_COD_BANCO IN NUMBER,
INSERTMOV_COD_SUCUR IN NUMBER,
INSERTMOV_NUM_CTA IN NUMBER,
INSERTMOV_FECHA_MOV IN DATE,
INSERTMOV_TIPO_MOV IN CHAR,
INSERTMOV_IMPORTE IN NUMBER
);

DECLARE
 sql_str VARCHAR2(500):='';

BEGIN
 sql_str:=sql_str||'INSERT INTO MOVIMIENTOS (';
 dbms_output.put_line(sql_str);
END; 
/

share|improve this question

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

share|improve this question

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

edited Mar 9 at 9:21

William Robertson

8,51732233

edited Mar 9 at 9:21

William Robertson

8,51732233

asked Mar 9 at 0:54

VictorVictor

175

asked Mar 9 at 0:54

VictorVictor

175

2 Answers
2

active

oldest

votes

1

Sample syntax:

create or replace procedure insert_movimientos
 ( insertmov_cod_banco in number
 , insertmov_cod_sucur in number
 , insertmov_num_cta in number
 , insertmov_fecha_mov in date
 , insertmov_tipo_mov in varchar2
 , insertmov_importe in number )
is
 sql_str varchar2(500) := 'INSERT INTO MOVIMIENTOS (';
begin
 dbms_output.put_line(sql_str);
end;
/

The trailing slash is for the client application so may not be required depending on what tool you are using.

I changed the datatype for insertmov_tipo_mov. char adds blank spaces which nobody needs, and is provided mainly for ANSI compatibility. It's best to use the standard type.

Even better, use table name.columnname%type to anchor it to the type of the corresponding table column.

A lot of examples online are in uppercase, for no clear reason. You don't as a rule write computer code in uppercase.

share|improve this answer

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how to execute this procedure i dont know, sorry I'm starting
  
  – Victor
  Mar 9 at 11:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am trying with EXEC INSERT_MOVIMIENTOS (0, 0, 0, '2008-11-11', 'o', 0); and answer with "ERROR at line 1: ORA-01861: literal does not match format string ORA-06512: at line 1"
  
  – Victor
  Mar 9 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The 4th parameter needs to be a date literal or variable, not '2008-11-11'. Have a look at the documentation for date literals.
  
  – William Robertson
  Mar 9 at 12:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok the date was wrong, thanks :)
  
  – Victor
  Mar 9 at 12:14
  

  
  
  
  

add a comment | 

0

Remove extra ;, or write IS

Syntax of create procedure

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
 ...
)
IS
 sql_str VARCHAR2(500):='';
 ...
;

share|improve this answer

edited Mar 9 at 10:39

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There's no declare unless you need a sub-block, in which case it would need to go after the first begin.
  
  – William Robertson
  Mar 9 at 9:17
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072935%2ferror-creating-procedure-declare-and-end-error%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

Sample syntax:

create or replace procedure insert_movimientos
 ( insertmov_cod_banco in number
 , insertmov_cod_sucur in number
 , insertmov_num_cta in number
 , insertmov_fecha_mov in date
 , insertmov_tipo_mov in varchar2
 , insertmov_importe in number )
is
 sql_str varchar2(500) := 'INSERT INTO MOVIMIENTOS (';
begin
 dbms_output.put_line(sql_str);
end;
/

The trailing slash is for the client application so may not be required depending on what tool you are using.

I changed the datatype for insertmov_tipo_mov. char adds blank spaces which nobody needs, and is provided mainly for ANSI compatibility. It's best to use the standard type.

Even better, use table name.columnname%type to anchor it to the type of the corresponding table column.

A lot of examples online are in uppercase, for no clear reason. You don't as a rule write computer code in uppercase.

share|improve this answer

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how to execute this procedure i dont know, sorry I'm starting
  
  – Victor
  Mar 9 at 11:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am trying with EXEC INSERT_MOVIMIENTOS (0, 0, 0, '2008-11-11', 'o', 0); and answer with "ERROR at line 1: ORA-01861: literal does not match format string ORA-06512: at line 1"
  
  – Victor
  Mar 9 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The 4th parameter needs to be a date literal or variable, not '2008-11-11'. Have a look at the documentation for date literals.
  
  – William Robertson
  Mar 9 at 12:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok the date was wrong, thanks :)
  
  – Victor
  Mar 9 at 12:14
  

  
  
  
  

add a comment | 

1

Sample syntax:

create or replace procedure insert_movimientos
 ( insertmov_cod_banco in number
 , insertmov_cod_sucur in number
 , insertmov_num_cta in number
 , insertmov_fecha_mov in date
 , insertmov_tipo_mov in varchar2
 , insertmov_importe in number )
is
 sql_str varchar2(500) := 'INSERT INTO MOVIMIENTOS (';
begin
 dbms_output.put_line(sql_str);
end;
/

The trailing slash is for the client application so may not be required depending on what tool you are using.

I changed the datatype for insertmov_tipo_mov. char adds blank spaces which nobody needs, and is provided mainly for ANSI compatibility. It's best to use the standard type.

Even better, use table name.columnname%type to anchor it to the type of the corresponding table column.

A lot of examples online are in uppercase, for no clear reason. You don't as a rule write computer code in uppercase.

share|improve this answer

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how to execute this procedure i dont know, sorry I'm starting
  
  – Victor
  Mar 9 at 11:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am trying with EXEC INSERT_MOVIMIENTOS (0, 0, 0, '2008-11-11', 'o', 0); and answer with "ERROR at line 1: ORA-01861: literal does not match format string ORA-06512: at line 1"
  
  – Victor
  Mar 9 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The 4th parameter needs to be a date literal or variable, not '2008-11-11'. Have a look at the documentation for date literals.
  
  – William Robertson
  Mar 9 at 12:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok the date was wrong, thanks :)
  
  – Victor
  Mar 9 at 12:14
  

  
  
  
  

add a comment | 

Sample syntax:

create or replace procedure insert_movimientos
 ( insertmov_cod_banco in number
 , insertmov_cod_sucur in number
 , insertmov_num_cta in number
 , insertmov_fecha_mov in date
 , insertmov_tipo_mov in varchar2
 , insertmov_importe in number )
is
 sql_str varchar2(500) := 'INSERT INTO MOVIMIENTOS (';
begin
 dbms_output.put_line(sql_str);
end;
/

The trailing slash is for the client application so may not be required depending on what tool you are using.

I changed the datatype for insertmov_tipo_mov. char adds blank spaces which nobody needs, and is provided mainly for ANSI compatibility. It's best to use the standard type.

Even better, use table name.columnname%type to anchor it to the type of the corresponding table column.

A lot of examples online are in uppercase, for no clear reason. You don't as a rule write computer code in uppercase.

share|improve this answer

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

create or replace procedure insert_movimientos
 ( insertmov_cod_banco in number
 , insertmov_cod_sucur in number
 , insertmov_num_cta in number
 , insertmov_fecha_mov in date
 , insertmov_tipo_mov in varchar2
 , insertmov_importe in number )
is
 sql_str varchar2(500) := 'INSERT INTO MOVIMIENTOS (';
begin
 dbms_output.put_line(sql_str);
end;
/

share|improve this answer

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

answered Mar 9 at 9:45

William RobertsonWilliam Robertson

8,51732233

0

Remove extra ;, or write IS

Syntax of create procedure

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
 ...
)
IS
 sql_str VARCHAR2(500):='';
 ...
;

share|improve this answer

edited Mar 9 at 10:39

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There's no declare unless you need a sub-block, in which case it would need to go after the first begin.
  
  – William Robertson
  Mar 9 at 9:17
  

  
  
  
  

add a comment | 

0

Remove extra ;, or write IS

Syntax of create procedure

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
 ...
)
IS
 sql_str VARCHAR2(500):='';
 ...
;

share|improve this answer

edited Mar 9 at 10:39

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There's no declare unless you need a sub-block, in which case it would need to go after the first begin.
  
  – William Robertson
  Mar 9 at 9:17
  

  
  
  
  

add a comment | 

Remove extra ;, or write IS

Syntax of create procedure

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
 ...
)
IS
 sql_str VARCHAR2(500):='';
 ...
;

share|improve this answer

edited Mar 9 at 10:39

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

CREATE OR REPLACE PROCEDURE INSERT_MOVIMIENTOS (
 ...
)
IS
 sql_str VARCHAR2(500):='';
 ...
;

share|improve this answer

edited Mar 9 at 10:39

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413

answered Mar 9 at 7:15

Jahirul Islam BhuiyanJahirul Islam Bhuiyan

768413