Oracle Help
in [SQL]
|
passing CLOB in Stored Procedure as IN/OUT Hi, I am trying to get an answer for 'Is it required to create a temporary lob before doing an in/out operation on a lob being passed as in/out parameter in a stored-procedure?" I have seen some of the OCI samples, wherein temporary lob is created using OCILobCreateTemporary call and then we use OCILobWrite or... 24 Jun 2008 03:05
My Oracle DBA Blog. Hai all, I like to share my oracle DBA Blog. Visit it and check if it is useful for you. Thank you. http://arjudba.blogspot.com To know about How to get Oracle Error Message from Database or OS http://arjudba.blogspot.com/2008/06/how-to-get-oracle-error-message-from.html To know about How to Create and Use OMF... 24 Jun 2008 21:35
Conditional Union ? I am using 10g. Below is a crude example of what I am trying to do Procedure ( pi_input as interger ) is Cursor A is Select 'A' as Letter from Dual; Cursor B is Select 'A' as Letter from Dual; Union Select 'B' as Letter from Dual; If pi_input = 1 then Open A Else Open B End I... 20 Jun 2008 07:06
Trigger Invalid State What would cause a trigger to have an invalid state? Do triggers become invalid if you alter a table (but do not add/drop any columns that trigger references)? Do triggers become invalid if you add an index to a table? ... 19 Jun 2008 01:14
Can't Find localhost I have two problems I think are related. When I click go to oracle database from the desktop I get can not find page. If I change the ip adress to local host then it will open the oracle homepage. I also have an program that is using oracle as a background program when I go to open the program I get database not... 24 Jun 2008 16:27
Home Remodeling Improvement Locksmith Smart Home Moving & relocation Home Remodeling Improvement Locksmith Smart Home Moving & relocation Related Links: Moving Companies Movers http://www.movingcompanies.co.il http://movingcompanieslosangeles.blogspot.com/ http://movingcompaniescalifornia.blogspot.com http://longdistancemovingcompanies.blogspot.com http://crosscountrymovingcompan... 19 Jun 2008 01:14
bind parameter in existsnode function Got it... the two single quotes around the values in the @Value and @Name statements are escape characters too. This value //Key[@Value='True'] and //Key[@Name='Validation Status'] may be bound to a parameter just fine. ... 19 Jun 2008 01:14
REF CURSOR Hi, I may be answering my own question, but I want to make sure. Say I have a ref cursor that has a dynamic where clase, and in addition a bind variable that changes each time through the loop: OPEN cust_ref FOR 'SELECT customer_name, customer_address FROM customer WHERE customer_id = :v_customer... 19 Jun 2008 01:14
Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto http://locksmithhome.com/default.aspx ... 19 Jun 2008 01:14
SUBSTR & INSTR Hi, I'm looking to parse an email. Say I have an email like this: johnjones(a)gmail.abc.def.ghi.com I basically want johnjones(a)gmail.abc.def.ghi in one variable and the .com in the other. If the email is this: jjones(a)amail.co The same, I basically want jjones(a)amail.co in one variable and the .com i... 19 Jun 2008 01:14 |