ORA-06502: PL/SQL: numeric or value error

ORA-06502: PL/SQL: numeric or value error ORA-06502:PL/SQL: numeric or value error string Cause:An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2). Action:Change the data, how it is manipulated, or how it is declared...

Read More

ORA-00932: inconsistent datatypes: expected - got CLOB

ORA-00932: inconsistent datatypes: expected - got CLOB One thing I must share is, I have explained what I was facing and that is explained below. If  you are facing same problem then it is pleasure for me, my post is helpful for you. But if this is not the case then please visit following links may be you can find some thing for you. http://www.orafaq.com/forum/t/65196/2/ http://albert-myptc.blogspot.co.uk/2009/04/ora-00932-inconsistent-datatypes.html https://github.com/rsim/oracle-enhanced/issues/72 http://tracker.moodle.org/browse/MDL-21890 Can't...

Read More

Change The Message Template Of Purchase Order Email Notification in Oracle EBS

Change The Message Template Of Purchase Order Email Notification in Oracle EBS Change The Message Template, Remove the Approve & Reject Links, and Hide Request More Information Buttons from a Workflow E-mail Notification. 1.    Log-in to oracle apps, and switch to responsibility ‘Work Flow Administrator’. 2.    Open the Work Flow Manager under Oracle Application Manager Purchase Order Email...

Read More

Oracle ADPatch

ADPatch  Applying a patch updates your existing system in various ways, from adding a new feature or product to improving system performance. patches are applied for a number of reasons, including: ■ Fixing an existing issue ■ Adding a new feature or functionality ■ Updating to a higher maintenance level ■ Applying the latest product enhancements ■ Providing interoperability to new technology stacks ■ Determining the source of an issue ■ Applying online help Depending on the type of patch, it may update the file system, or the...

Read More

ORA 01652 unable to extend temp segment

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP ORA-01652: unable to extend temp segment by 128 in tablespace TEMP05   ORA-01652: unable to extend temp segment by string in tablespace string   Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.   Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to...

Read More