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-09700: sclin: maximum number of latches exceeded

1 Answers  


LCD-00219: nested include file [string] is too large

1 Answers  


ORA-08464: input raw decimal data contains more than 42 digits

1 Answers  


ORA-31621: error creating master process

1 Answers  


ORA-07241: slemrd: read error.

1 Answers  


NZE-28805: Cannot retrieve information from the data source.

1 Answers  


QSM-02062: GROUP BY clause in mv

1 Answers  


ORA-12026: invalid filter column detected

1 Answers  


RMAN-06126: skipping offline file string

1 Answers  


RMAN-06300: Report of files with less than number redundant backups

1 Answers  


ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  


ORA-13705: There was a instance shutdown/startup between the snapshots in the range [string, string].

1 Answers  


Categories