Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PLS-00204: function or pseudo-column 'string' may be used
inside a SQL statement only



PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only..

Answer / guest

Cause: A pseudocolumn or proscribed function was used in a
procedural statement. The SQL pseudocolumns (CURRVAL, LEVEL,
NEXTVAL, ROWID, ROWNUM) can be used only in SQL statements.
Likewise, certain functions such as DECODE, DUMP, and VSIZE
and the SQL group functions (AVG, MIN, MAX, COUNT, SUM,
STDDEV, VARIANCE) can be used only in SQL statements.

Action: Remove the pseudocolumn reference or function call
from the procedural statement. Or, replace the procedural
statement with a SELECT INTO statement; for example, replace
bonus := DECODE(rating, 1, 5000, 2, 2500, ...); with the
following statement: SELECT DECODE(rating, 1, 5000, 2, 2500,
...) INTO bonus FROM dual;

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6

1 Answers  


ORA-37102: (XSVPART02) Invalid partition name string.

1 Answers  


ORA-13207: incorrect use of the [string] operator

1 Answers  


ORA-32587: Cannot drop nonexistent string supplemental logging

1 Answers  


PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

1 Answers  


PCC-02372: FOR clause not allowed in SELECT statement

1 Answers  


ORA-26086: direct path does not support triggers

1 Answers  


ORA-16204: DDL successfully applied

1 Answers  


ORA-31490: could not attach to LogMiner session

1 Answers  


ORA-01598: rollback segment 'string' is not online

1 Answers  


ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


CLSS-02207: error string getting status from vendor node monitor

1 Answers  


Categories