| Problem with executing in isqlplus (oracle 9.0.1.0.1) (merged cross-posts) [message #129316] |
Sat, 23 July 2005 19:34  |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Hi
In isqlplus , some special characters(like '+') is giving errors after compling the program.It is not dispalying in the program(script).Error message follows
result := (v_num1/v_num2) v_num2;
*
ERROR at line 6:
ORA-06550: line 6, column 27:
PLS-00103: Encountered the symbol "V_NUM2" when expecting one of the following:
* & = - + ; < / > at in is mod not rem <an exponent (**)>
<> or != or ~= >= <= <> and or like between overlaps || year
DAY_
The symbol "*" was substituted for "V_NUM2" to continue.
please give me solution for this
thanks
rajesh
|
|
|
|
|
|
| Re:isqlplus error (more details) [message #129342 is a reply to message #129316] |
Sun, 24 July 2005 09:03  |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Thank you Maaher for your prompt reply
I'll provid you more details now.
I'm using XP home edition, database version oracle 9.0.1.0.1 and browser IE version 6.0.
I wrote the script in isqlplus.Saved.When i execute script , the script doesnt have the arithmetic operators(+,-) and it throwing this error.
-----------------------------------------
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
*
ERROR at line 5:
ORA-06550: line 5, column 54:
PLS-00103: Encountered the symbol "NVL" when expecting one of the following:
) , * & | = - + < / > at in is mod not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like
between ||
The symbol "," was substituted for "NVL" to continue.
------------------------------
I'll provide you my program.Please advice me , if there is any adjustment in executing program or in the appache server.This program working perfectly in sqlplus.Please execute this program in isqlplus and advice me.
This is my program.
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 + nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
----------After executing th script became like this
and showing above error message.
---------------------------------
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
------------------------
Thanks in advance
Rajesh
|
|
|
|
| Re:isqlplus error (more details) [message #129384 is a reply to message #129342] |
Sun, 24 July 2005 23:18 |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
Hi,
Why can't you place the expression something like following and try.
(1 + ((nvl(v_bonus,0))/100)).I feel the issue is for operator precedence.
Not sure , just give a try.
--Kiran
|
|
|
|
| Re:isqlplus error (more details) [message #129388 is a reply to message #129384] |
Sun, 24 July 2005 23:28 |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Hi kiran,
The problem is not only for '+' and '-' operators, but also for %(eg. %type, sql%rowcount).When I retrieve the file from saved one, instead of % , the program shows some junk characters.In place of '+' and '-' it shows blank.As a result of these problems i'm getting error.
Please give me some advice for this
Thanks in advance
Rajesh
|
|
|
|
|
|
| Problem with isqlplus execution [message #129958 is a reply to message #129316] |
Wed, 27 July 2005 07:38 |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Hi
I have some problems in isqlplus.i'm providing all the details.
I'm using XP home edition, database version oracle 9.0.1.0.1 and browser IE version 6.0. and oracle provided HTTP(apache) server.
I wrote the script in isqlplus.Saved.When i execute script , the script doesnt have the arithmetic operators(+,-) and it throwing this error.More over in place of '%'(eg: sql%rowcount) character some other characters are coming.
-----------------------------------------
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
*
ERROR at line 5:
ORA-06550: line 5, column 54:
PLS-00103: Encountered the symbol "NVL" when expecting one of the following:
) , * & | = - + < / > at in is mod not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like
between ||
The symbol "," was substituted for "NVL" to continue.
------------------------------
I'll provide you my program.Please advice me , if there is any adjustment in executing program or in the appache server.This program working perfectly in sqlplus.Please execute this program in isqlplus and advice me.
This is my program.
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 + nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
----------After executing th script became like this
and showing above error message.
---------------------------------
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
------------------------
Thanks in advance
Rajesh
|
|
|
|
| Problem while executing in isqlplus(oracle 9.0.1.0.1) [message #130145 is a reply to message #129316] |
Thu, 28 July 2005 07:46 |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Hi Gurus,
I have some problems in isqlplus.i'm providing all the details.
I'm using XP home edition, database version oracle 9.0.1.0.1 and browser IE version 6.0. and oracle provided HTTP(apache) server.
I wrote the script in isqlplus.Saved.When i execute script , the script doesnt have the arithmetic operators(+,-) and it throwing this error.More over in place of '%'(eg: sql%rowcount) character some other characters are coming.
-----------------------------------------
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
*
ERROR at line 5:
ORA-06550: line 5, column 54:
PLS-00103: Encountered the symbol "NVL" when expecting one of the following:
) , * & | = - + < / > at in is mod not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like
between ||
The symbol "," was substituted for "NVL" to continue.
------------------------------
I'll provide you my program.Please advice me , if there is any adjustment in executing program or in the appache server.This program working perfectly in sqlplus.Please execute this program in isqlplus and advice me.
This is my program.
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 + nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
----------After executing th script became like this
and showing above error message.
---------------------------------
define p_salary=50000
define p_bonus=10
set verify off
set serveroutput on
DECLARE
v_salary number :=&p_salary;
v_bonus number :=&P_bonus;
begin
dbms_output.put_line(to_char(nvl(v_salary,0) * (1 nvl(v_bonus,0)/100)));
end;
/
set serveroutput off
set verify on
------------------------
Expecting a quick reply from you,
Thanks in advance
Rajesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
