Search results for query: *

I have some minor problems and if you can may be you could help me because I can not find an answer to this errors. Thanks a lot. I have a problem with a line 57 ("open l_cursor for SQLQuery;") and last line where I have "/". Please help. Thanks again. 57 PLS-00103...

I have a stored procured in SQL and I need to re-write it for ORACLE 8. I am new in Oracle and still learning. Please Help. Thanks a lot. CREATE PROCEDURE SearchProductCategory @Product as varchar(50), @SearchTypeProd as int, @Category as varchar(50), @SearchTypeCat as int AS declare @SQL as...

Thanks for your help but I still have a problem. I am trying to execute package/Procedure and I am getting an error: ORA-00604: error occurred at recursive SQL level 1 ORA-01460: unimplemented or unreasonable conversion requested ORA-06512: at "SYS.DBMS_LOB", line 370 ORA-06512: at...

I've been tring to post same question for a 3rd time and can not get even one helpfull answer. Please if you do not know do not answer and do not give me answers like "see this link or that" I am trying to run SQL statement to update one field with a datatype "clob" and...

I am trying to run SQL statement to update one field with a datatype "clob" and SQL give me an error "ORA-01704: string literal too long ". The len of the string I am trying to save is 8336 chr. It could be longer or shorter depending on a webpage. If I take only 4000 chr...

I am trying to rur SQL statement to update one field with a datatype "clob" and SQL give me an error "ORA-01704: string literal too long ". The len of the string I am trying to save is 8336 chr. It could be longer or shorter depending on a webpage. If I take only 4000 chr...

How can I get a select of 12 month starting with current month down. Example 06/2002, 05/2002,..........08/2001,07/2001 Please help Thanks for your help