Search results for query: *

I am not able to use UNION because by using Union, string length of actual query are coming out about 7500 character which can not be stored in VARCHAR2. So I thought to break into differect select statement, execute them separately, bind the result set and finally send back. Pls, Suggest. Manoj

Hi Sem, Thanks for your reply. But i am not able to assignt this value. Someone is saying that I can't assign value > 4000. Can you please tell me any alternate sol. Manoj

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

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

My stored procedure is being called from the crystal report and hence I am getting the problem. My code is very big and to explain it in a simpler way, I skipped something which might confuse you people. Hope, you would now like to suggest something. Manoj

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

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

Hi Ido, Thanks a lot. It solved. cheers, Manoj

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'...

Hi, thank for your reply.. The link says to create a function on memo type and use this in group but I am facing two problems. 1. The memo field doesn't comes in the formula editor so how can I create a formula on this. 2. I created another formulata (just for test purpose) but while creating...

Thanks, I got the problem.. It was table privileges problem.

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

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

Hi, We can use If..Else... my package is written with Pl/SQL and we can you Pl/SQL as below. procedure test(a in number) IS Begin If a>10 Then a:=a-10; else a:=a+10; end if; dbms_output.put_line(a); End; cheers, Manoj

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

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