Yes, we can use the TCL commands(commit/rollback) in the exception block of a stored procedure/function. The code in this part of the program gets executed like those in the body without any restriction. You can include any business functionality whenever a condition in main block(body of ...
In earlier versions of IIS, if we wanted to send a user to a new Web page, the only option we had was Response.Redirect. While this method does accomplish our goal, it has several important drawbacks. The biggest problem is that this method causes each page to be treated as a separate...
In COBOL Explorer, expand BANKDEMO / config. In the editor, open BANKDEMO_ED.json. Find string ED_Home= and change path to point to the Enterprise Developer project, as follows: D:\\<username>\\workspace\\BANKDEMO. Note the use of double slashes (\\)in the path definition. Save and...
and Pointers are used to identify the address of variables,methods, and therefore even big programmer can find out the secrets of other user on the internet using pointer. so if there could be pointer in java, it could be harmful for leakage of the important information. Was this answer u...
When you return a ref cursor, you are returning a pointer variable. Was this answer useful? Yes ReplyAniruddha Das Jun 11th, 2012 If you want to take care of performance tuning you need to take care of sub-queries as they takes a lot of time to executing in side the pl-sql ...
CURSOR cur IS SELECT col FROM table WHERE something; BEGIN OPEN cur; FETCH cur INTO var; CLOSE cur; END; Was this answer useful? Yes Replyhira Aug 8th, 2013 When ever any query execute by the server in database sever itself create a implicit cursor ,which can not any control ...
Suppose, if my script is having multiple Actions, each with different business process and if i need to get fractional percentage weightages for each business process - then, we create a block that runs 1% of the time, and put an action in the block that runs 10% of the time. So, to...
Fatal error is generated only once in "require_once", but the error is repeated in "require" & "include". Was this answer useful? Yes ReplyHarindersingh1985 Apr 10th, 2009 require 'file1': It will include the code of the file1. In case file1 does not exist it will generate ...