Recent content by Cisco

OK, let me put a couple of paragraphs together and I will send them your way. Shoud I send them on private email ? Thanks

Marco, What would it take to have this functionality on the next version ( Or a custom version ) of DOA ?

Is this something that is going to be implemented at some point ? Thanks

Use a Test window. Then do the following select yourfunctionname() into :thedata from dual; Then sacn variables and set thedata as a cursor Press F8 Then open the thedata varibale to see the data

Does PL/SQL Dev or DOA provide any sort of functionality to support proxy user usage ? Thanks

Hi Marco; Same problem when I try SQL*Plus. so I guess the problem is with 10g. Thanks

HI :-) I used to issue the following command ( using a PL/SQL Dev command window ) in Oracle 8i CREATE TABLESPACE CISCOBISCO DATAFILE 'HS_F0_CISCOBISCO ' SIZE 200 M REUSE AUTOEXTEND ON NEXT 2 M MAXSIZE UNLIMITED DEFAULT STORAGE(INITIAL 64K NEXT 64K PCTINCREASE 0 MAXEXTENTS UNLIMITED) The data...

Can you please give credit to whom ever give you this code.. It looks alot like the code I wrote... Originally in this thread http://www.allroundautomations.com/ubb/Forum1/HTML/000778.html

The procedures should be like this: PROCEDURE InitClob( Clobname IN OUT CLOB)IS BEGIN dbms_lob.CreateTemporary( Clobname, FALSE); END; PROCEDURE FreeClob( Clobname IN OUT CLOB)IS BEGIN dbma_lob.FreeTemporary(Clobname); END;

I did not see nay problems.. The InitClob and FreeClob procedures need to have IN OUT parameters.. Can you post a little bit of your code so I can see what is that you are doing ... You can also email me if you do nto want to post it here.. fjuarez@appropriatesolutions.com

OK, so here is what I did. I have 2 procedures in my pakcage like this: PROCEDURE InitClob( Clobname CLOB)IS BEGIN dbms_lob.CreateTemporary( Clobname, FALSE); END; PROCEDURE FreeClob( Clobname CLOB)IS BEGIN dbma_lob.FreeTemporary(Clobname); END; Those procedures live in the server (...

OK, so I was able to figure out how to do it. You can actually use a CLOB to transport data back and forth with out having a CLOB type column. Here is what I am doing: I have a procedure that takes XML as IN variable ( the XML could be anywhere from 1k to ?? )so using a varchar2 was no help. I...

The problem is that I do not have a CLOB column. The CLOB variable will have a huge amount of xml that the procedure will use to manipulate different tables...

I have a procedure that I need to call, the procedure is as follows: procedure(:largetext, :smalltext, :success) this procedure takes a CLOB, VARCHAR2, BOOLEAN. I need help witting to the CLOB variable. I have about 500 kb of text that need to be written to the CLOB. How can I achieve that?