In my program I got multiple spots where I open a Connection to an Oracle database, read some lines via a stored procedure which returns me a cursor, put them in an IDataReader, close the connection a
Can anyone help me with this exception? ORA-01438: value larger than specified precision allowed for this column
I have variable LRowNode DBMS_XMLDOM.DOMNode; contains (example) <N_4883636> <TID_23787542>12</TID_23787542>
In PL SQL, I\'m writing a stored procedure that uses a DB link: CREATE OR REPLACE PROCEDURE Order_Migration(us_id IN NUMBER, date_id in DATE)
For Nested table i have done it in follwing way? This is pl/sql stored procedure. CREATE or REPLACE PROCEDURE TEST(
I have following error message. 2011-08-08 14:27:09 [E]: xxx - ORA-06502: PL/SQL: numeric or value error:
Notepad++ can match ( ), { }. I use it to edit pl sql code, and wonder if it is able to match beginning and end of a pl sql开发者_如何学运维 block
I\'d like to create an in-memory array variable that can be used in开发者_运维知识库 my PL/SQL code.I can\'t find any collections in Oracle PL/SQL that uses pure memory, they all seem to be associated
Sometimes the exception returns something like: \"ORA-06502: PL/SQL: numeric or value error: character string buffer too small\".
I have a query that needs to check that all fields have values are in a list of valid codes. Right now I\'m calling the same subquery over and over and over again. I want to abstract the subquery out
加载中,请稍侯......