Search results for query: *

Hi, I have table with a CLOB column. While I try to display data, it shows nothing. I am doing this in TOAD 7.4. Any idea how to resolve this.. Thanks in advance

Actually I have written a small Java program that uses split() function and returns String[]. I want to use this program in a PL/SQL procedure. I am stuck at publishing the Java function. I tried: CREATE OR REPLACE FUNCTION MIG_USER.SPLIT_STR (STR VARCHAR2, DELIM VARCHAR2) RETURN VARRAY(20)...

Hi, Can I tokenize a big String into token with separators like Space or Comma in PL/SQL? Thanks in advance,

Hi, I have already installed Metadata Reporter for PowerMart 6.2. I'm trying to install Metadata Reporter on a J2EE compliant Server such as Sun ONE Application Server or J2EE RI Ver 1.4. Can anyone tell me what components I need to deploy and HOW? I see many class files and XMLs Thanks in...

Hi, We have to populate data from 2 tables into one table. The 2 source tables don't have any relations. What will be the best approach to create mapping for this ? Thanks in advance,

Hi, How can I know what is the cutoff value in Oracle that determined if a date is in Century 19 or 20? For Example, If I specify 13-MAR-85, is it 1985 or 2085? Where this cutoff is specified? Thanks in advance

TOAD is very good too...

Hi, Is there a way to prompt users to provide a date value for a parameter in procedure? Also, I want that the date value to be "treated" in format of DD-MON-YYYY. Users will enter in this format e.g. 12-MAR-1901. Thanks,

Hi, There is a date parameter that is passed in a procedure. The procedure is run externally from TOAD and a value of '12-MAR-1901' is provided. When it runs, it takes up '12-MAR-01' which is treated as '12-MAR-2001'. How can I prevent this ? Thanks in advance. Any help is appreciated....

Hi, Inside a procedure, I'm trying to run: var1 varchar2 (20), var2 number, CURSOR C1 IS SELECT col3 FROM SCHEMA_NAME.REF_TABLE FOR UPDATE; .... FOR C1_REC IN C1 LOOP 'SELECT B.COL1, B.COL2 INTO VAR1, VAR2 '|| 'FROM SCHEMA1.MASTER_TAB@db23_LINK B ' || 'WHERE B.COL2 = '''||...

How should I start several sessions?

Hi, I want to handle exception in a way that I can get some more data out of the exception thrown by Oracle. For example, I get an error code -942 which is for table or view not found. I also want to know "what" table of view is not found. Can I get to know from Oracle what table or...

Yes. I have a dynamic cursor that reads and writes.

Hi, Is there a way to run multiple procedures from inside a main procedure so that these procedures run in parallel? I mean can I tell Oracle to run 10 procedures in parallel? Actually, I have a data loading requirement of loading 10 tables in parallel and I was thinking if I can write 10...

Hi, I have a requirement where I'll be extracting records from some 10 tables and load into another 10 tables. I want this loading to happen in parallel. I will write a PL/SQL procedure to accomplish it where I'll be passing table name and some search criteria. This will be inside a loop...

It's Solved ! I was stupid and not looking at the SQL generated by TOAD. It was defining the parameter to VARCHAR2 (22) which was not enough for it. So, when I changed it to 2000, it ran. So I think If I 'm running the procedure from TOAD, the default length it takes for VARCHAR2 is 22...

Is there anything that has to do with the parameter? As I am not specifying the parameter length, can that cause error? CREATE OR REPLACE FUNCTION Display_Message ( OUTPUT_TEXT IN VARCHAR2 ) RETURN NUMBER IS What length it'll assume?

I tried with...

I tried passing: 'This is a very big string and it'll not fit into simple 255 limit of DBMS_OUTPUT.PUT_LINE. So I had to write a small procedutre to make it visiblein the OUTPUT window of DBMS_OUTPUT. Hope everyone will like it. It also doesn't eliminate any character so it's pretty raw in...

I'm getting these: ORA06502: PL/SQL:numeric or value error: character string buffer too amall ORA06512: at line 6