error while running procedure [message #631701] |
Sun, 18 January 2015 23:46 |
|
chavva.kiru@gmail.com
Messages: 23 Registered: April 2012 Location: hyderabad
|
Junior Member |
|
|
hi All,
while i complied the attached procedure.It went fine.
While Executing as below
declare
aos_return varchar2(200);
begin
fdw.upd_mon_reg_4_extracts
('reg_extracts','s_test','02/28/2015','380',aos_return);
dbms_output.put_line(aos_return);
end;
/
error at line 1:
ora 29288 invalid file name
ora 06512 fdw.sp_log line 160(this no in attachment is
different)
ora 06512 fdw.upd_mon_reg_4_extracts line 225(this no
in attachment is different)
ora 06502 pl/sql numeric or value error:character to
number conversion error.
ora 06512 at line 4.
pls let me know how to resolve this errors.
|
|
|
Re: error while running procedure [message #631703 is a reply to message #631701] |
Sun, 18 January 2015 23:55 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Please read and follow the OraFAQ Forum Guide and How to use [code] tags, to enable us to help you.
Better to post the procedure as text rather than attachment, and use code tags.
chavva.kiru@gmail.com wrote on Mon, 19 January 2015 11:16
ora 06502 pl/sql numeric or value error:character to number conversion error.
You are trying to assign a non-numeric value to a numeric variable. For example,
SQL> DECLARE
2 v_num NUMBER;
3 BEGIN
4 v_num := 'x';
5 dbms_output.put_line(v_num);
6 END;
7 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4
SQL>
|
|
|
Re: error while running procedure [message #631705 is a reply to message #631701] |
Mon, 19 January 2015 00:22 |
|
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
From your previous topic:
Michel Cadot wrote on Thu, 16 August 2012 16:20From your previous topics:
BlackSwan wrote on Wed, 11 April 2012 16:43Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
BlackSwan wrote on Wed, 11 April 2012 20:29...
READ & FOLLOW the Posting Guidelines! http://www.orafaq.com/forum/t/88153/0/
With any SQL question, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
Regards
Michel
In addition, Barbara helped you so much in your previous topics providing you codes and examples and you did never feedback and thank her.
Are you the kind of parasite we saw too much in these days?
Or are you a valuable person who deserves to be helped?
|
|
|
|