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 John Tel 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: *

  • Users: manush
  • Content: Threads
  • Order by date
  1. manush

    VARCHAR2 datatype for very long string data

    Hi, I declared a variable in my stored procedure as strSQL VARCHAR2(8000); Because I have a very long string with select query using 4-5 UNIONs. The length of my string is about 7500 But I am not able to assign it in strSQL. If we can't declare VARCHAR2 with such a long length, can what is...
  2. manush

    Binding output of two resultset in PL/SQL and sending back by atribute

    Hi, I have two string containing two queries like str1 VARCHAR2(1000); str2 VARCHAR2(1000); str1 := Select 'Test1' from dual; str2 := Select 'Test2' from dual; In PL/SQL, to get the result set of ONE query I use OPEN o_result_set FOR str1; Where o_result_set is IN OUT refcursor in stored...
  3. manush

    Binding resultset of output of 2query and returing back from PL/SQL

    Hi, I have two string containing two queries like str1 VARCHAR2(1000); str2 VARCHAR2(1000); str1 := Select 'Test1' from dual; str2 := Select 'Test2' from dual; In PL/SQL, to get the result set of ONE query I use OPEN o_result_set FOR str1; Where o_result_set is IN OUT refcursor in stored...
  4. manush

    How to give very long string data in string type variable of PL/SQL

    Hi, I declared a variable in my stored procedure as strSQL VARCHAR2(8000); Because I have a very long string with select query using 4-5 UNIONs. The length of my string is about 7500 But I am not able to assign it in strSQL. If we can't declare VARCHAR2 with such a long length, can what is...
  5. manush

    Length of Database field in Crystal Report

    Hi, My package has a query as below. Select 'NFE A' "nfe" from dual This pkg is called from crystal report and in field explorer the field comes as below. NFE: String[5] And the value comes in the report as ..... NFE A Now I change my query and recompile the package Select 'Primary'...
  6. manush

    Database Field of "Memo type" in crystal report

    Hi, I have two fields in oracle as below component_alias not null VARCHAR2(32) attribute_address not null VARCHAR2(2000) I am using a select query in my package as below select component_alias "Alias", attribute_address "Address" from component_header; Now I am calling this package from...
  7. manush

    package run from sql*plus but gives error when called from crys report

    Hi, I have a package which when executed from sql*plus, gives result but when called from crystal report, gives 0ra-01861 literal does not match format string. The input to the procedure are as below procedure try( in_region IN VARCHAR2, in_RTU IN VARCHAR2, in_start_time IN VARCHAR2...
  8. manush

    "Not Supported"-- Error message

    Hi, I wrote a pl/sql package and used it in crystal report to get the data. Then I made some changes (some more criteria using If..Else )in the pl/sql package and compiled it again. It compiled well without giving any error. Then I tried to use it in the same report as well as I created a...
  9. manush

    Not Supported -- Err msg coming in Crystal Report

    Hi, I wrote a pl/sql package and connected it to crystal report to access the oracle database and it worked fine. Then I changed the package where I used a string variable to write SQL and then used DBMS.SQL package to execute the same sQL. My package compiled well but when I tried to preview...

Part and Inventory Search

Back
Top