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

CLSR-00508: Invalid message number number

1 Answers  


ORA-06915: CMX: unknown t_event in datarq

1 Answers  


ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

1 Answers  


IMP-00400: Warning: Object type "string"."string" already exists with a different typeid

1 Answers  


ORA-01269: Destination parameter string is too long

1 Answers  


TNS-04014: Current instance string is already started

1 Answers  


RMAN-06454: duplexed backups require Enterprise Edition

1 Answers  


ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified

1 Answers  


ORA-08001: maximum number of sequences per session exceeded

1 Answers  


AMD-00153: error detaching workspace "string"

1 Answers  


TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number

1 Answers  


RMAN-20502: DELETE EXPIRED cannot delete objects that exist - run CROSSCHECK

1 Answers  


Categories