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

ORA-00075: process "string" not found in this instance

1 Answers  


QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

1 Answers  


PCC-02383: Expecting an expression of type OCIExtProcContext

1 Answers  


QSM-02009: non-inner join

1 Answers  


SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

1 Answers  


SQL*Loader-00950: Error shipping data structures across 2-task

1 Answers  


ORA-16129: unsupported dml encountered

1 Answers  


QSM-02003: aggregate function nested within an expression

1 Answers  


PLS-00322: declaration of a constant 'string' must contain an initialization assignment

1 Answers  


ORA-12441: policy string already exists

1 Answers  


ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


ORA-00269: specified log file is part of thread string not string

1 Answers  


Categories