Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
java.sql.SQLException: Invalid column type Error when extending a VO
What you need to change is the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional.
What you need to change is the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional.
See lesshow to create dynamic tables ,columns, and datatype for each column in oracle ?
hello @Tiwari Sandeep what i meant is i want create table at run time like create table tablename (col1 varchar2(50), col2 number); actually we can do this by dynamic SQL but it's unfortunately not recommended by oracle because this will open a loophole for hackers by (SQL INJECTION) if you have anyRead more
hello @Tiwari Sandeep what i meant is i want create table at run time like
actually we can do this by dynamic SQL but it’s unfortunately not recommended by oracle because this will open a loophole for hackers by (SQL INJECTION) if you have any idea to avoid this will be very appreciated
thank you for your reply.
See lessHow to Raise User-Defined Exception and display Custom SQLERRM ?
you can do this by using : RAISE_APPLICATION_ERROR function and here simple example for you : DECLARE custom_ex EXCEPTION; PRAGMA EXCEPTION_INIT (custom_ex, -20001); BEGIN raise_application_error (-20001, 'Your custom error message here'); EXCEPTION WHEN custom_ex THEN dbms_output.put_line (sqlerrm)Read more
you can do this by using : RAISE_APPLICATION_ERROR function and here simple example for you :
DECLARE custom_ex EXCEPTION; PRAGMA EXCEPTION_INIT (custom_ex, -20001); BEGIN raise_application_error (-20001, 'Your custom error message here'); EXCEPTION WHEN custom_ex THEN dbms_output.put_line (sqlerrm); END;the output would be : ” ORA-20001: Your custom error message here ” .
See lesshope this help 🙂
How to know number of rows updated by UPDATE statement ?
SQL%ROWCOUNT : return the number of rows fetched/processed by the last DML executed. If the DML fails after fetching 1 row, due to any reason, SQL%ROWCOUNT will return only 1, the number of rows fetched/processed so far basically you can use : BEGIN UPDATE xx_test_tab SET test_col = 777777 WHRead more
SQL%ROWCOUNT : return the number of rows fetched/processed by the last DML executed. If the DML fails after fetching 1 row, due to any reason, SQL%ROWCOUNT will return only 1, the number of rows fetched/processed so far
basically you can use :
hope this help 🙂
See lessCan i use select statement inside if statement ? (if (select) > 0 then) ?
hello Beter, you can't use SQL Statement directly in a PL/SQL expression instead you can use variable to store your count then use your variable into PL/SQL expression like this : DECLARE v_count NUMBER;BEGIN SELECT count (*) INTO v_count FROM dual; IF v_count >= 1 THEN dbms_output.put_liRead more
hello Beter,
you can’t use SQL Statement directly in a PL/SQL expression instead you can use variable to store your count then use your variable into PL/SQL expression like this :
or as you mentioned if you want to use it inside delete statement like this :
hope this helpful 🙂
See lessHow to Insert data include symbol '&' into a table ?
it's very simple just using this : set define off insert into table values ('& yourvalues'); and then press 'F5' to execute the above commands. also from sqlplus you can use this : set define off
it’s very simple just using this :
set define off insert into table values ('& yourvalues');and then press ‘F5’ to execute the above commands.
See lessalso from sqlplus you can use this :
set define off
How can i convert CLOBS TO VARCHAR2 column ?
hello Beter, you can use dbms_lob.substr( clob_column, for_how_many_bytes, from_which_byte ); and here basic two example : first by using SQL but note the max length is 4000 characters: select dbms_lob.substr( clob_col, 4000, 1 ) from Tablename; second by using PL/SQL max length is 32000 charactersRead more
hello Beter,
you can use
and here basic two example :
first by using SQL but note the max length is 4000 characters:
second by using PL/SQL max length is 32000 characters :
DECLARE var1 LONG; BEGIN FOR i IN (SELECT clob_col FROM tablename) LOOP var1 := dbms_lob.substr (i.clob_col, 32000, 1); END LOOP; END;hope this may help.
See lessyou can refer to DBMS_LOB from oracle
Load image
firstly, try to read more about the webutil library.second, find below a basic code snippet to do the job: --this code to open uploading dialog box V_CLIENT_PATH := CLIENT_GET_FILE_NAME(DIRECTORY_NAME => NULL ,FILE_NAME => NULL ,FILE_FILTER => 'ALL FILES (*.*)|*.*' ,MESSAGE => 'Open a fiRead more
firstly, try to read more about the webutil library.
second, find below a basic code snippet to do the job:
--this code to open uploading dialog box V_CLIENT_PATH := CLIENT_GET_FILE_NAME(DIRECTORY_NAME => NULL ,FILE_NAME => NULL ,FILE_FILTER => 'ALL FILES (*.*)|*.*' ,MESSAGE => 'Open a file' ,DIALOG_TYPE => NULL ,SELECT_FILE => NULL); -- create directory on local machine at client server HOST ( 'cmd /c mkdir'||' "'|| 'C:tempapplication' || '"',NO_SCREEN); -- this code to show uploading progress to user V_SUCCESS := WEBUTIL_FILE_TRANSFER.CLIENT_TO_AS_WITH_PROGRESS (CLIENTFILE => V_CLIENT_PATH ,SERVERFILE => V_SERVER_PATH ,PROGRESSTITLE => 'Uploading file in progress' ,PROGRESSSUBTITLE => 'Please wait' ,ASYNCHRONOUS => FALSE ,CALLBACKTRIGGER => NULL);hope this may help 🙂
See lessHow to add ' "single quotes" for string using Java?
hello beter, basically if you want to add single code to any string you can use : /' "any string you want here" /' and if you want to use it inside sql statement hence you are building VO at run time (onthefly :)) so you can write : SELECT column1 FROM table WHERE column2 = + "'"+ Vstr+"'"; where VsRead more
hello beter,
basically if you want to add single code to any string you can use :
and if you want to use it inside sql statement hence you are building VO at run time (onthefly :)) so you can write :
where Vstr is your String variable in your example.
See lesshope this helpful 🙂
share today to gain tomorrow.
How to pass date parameter to oracle report builder ?
hello albert, your code is correct can you write what is the error exactly to help you. in addition you can check your user parameter in your report builder property specifically these properties mentioned in below image
hello albert,
See lessyour code is correct can you write what is the error exactly to help you.
in addition you can check your user parameter in your report builder property specifically these properties mentioned in below image