Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. borisch

    Creating dynamic stored procedure problem

    No that is not a reason 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...
  2. borisch

    Creating dynamic stored procedure problem

    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...
  3. borisch

    Need help to Create Dynamic Stored Procedure

    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...
  4. borisch

    ATTN: SPENGLERR Error when DBMS_LOB.fileopen

    thanks a lot. It helped. thanks again.
  5. borisch

    ATTN: SPENGLERR Error when DBMS_LOB.fileopen

    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...
  6. borisch

    can anyone give me a straight answer about clob datatype

    thanks a lot
  7. borisch

    can anyone give me a straight answer about clob datatype

    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...
  8. borisch

    ORA-01704: string literal too long

    yes, if I make a string 4000 chr it work but how can i saqve 8000 0r 10000 or even more? I need to use clob as a field datatype. I can create a package and pass string of 8000 chr into package but looks like I will have same error that string is too long. How can I insert/update/select value...
  9. borisch

    ORA-01704: string literal too long

    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...
  10. borisch

    Problem Updating field with a CLOB datatype

    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...
  11. borisch

    How can I get a select of 12 month starting with current month down

    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

Part and Inventory Search

Back
Top