Home » SQL & PL/SQL » Client Tools » Problem with executing in isqlplus (oracle 9.0.1.0.1) (merged cross-posts)
Problem with executing in isqlplus (oracle 9.0.1.0.1) (merged cross-posts) [message #129316] Sat, 23 July 2005 19:34 Go to next message
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 [message #129335 is a reply to message #129316] Sun, 24 July 2005 04:54 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Why don't you try posting something more than one line of code.

I've tried it on my box ( Oracle 9.2.0.6 on XP pro ) and I have no problems.

Also version info can be useful: database, os, browser...

MHE
Re:isqlplus error (more details) [message #129342 is a reply to message #129316] Sun, 24 July 2005 09:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re:isqlplus error (more details) [message #129403 is a reply to message #129388] Mon, 25 July 2005 02:03 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Working perfectly on my machine. But really a good bug, i m also keen to know the results.

Tarun
Problem with isqlplus execution [message #129958 is a reply to message #129316] Wed, 27 July 2005 07:38 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: isql*plus
Next Topic: ORA-00904: "PARTITION_STOP": invalid identifier in toad
Goto Forum:
  


Current Time: Tue Aug 11 08:48:51 CDT 2020