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

NNL-00266: Round trip time is string

1 Answers  


ORA-31067: XML nodes must be updated with nodes of the same type

1 Answers  


ORA-23354: deferred RPC execution disabled for "string" with "string"

1 Answers  


ORA-15124: ASM file name 'string' contains an invalid alias name

1 Answers  


ORA-00476: RECO process terminated with error

1 Answers  


ORA-07390: sftopn: translate error, unable to translate file name.

1 Answers  


KUP-11006: file truncated error in string

1 Answers  


NNO-00334: region load failure: ROS admin_region type number unsupported

1 Answers  


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


IMP-00037: Character set marker unknown

1 Answers  


ORA-16505: site ID is invalid

1 Answers  


Categories