Hi All,
I wrote a procedure to clear all my text fields and disable all buttons in my form. And I call this procedure in a button (insert button). when I presses the insert button, after all my button operations, all the text fields get cleared and all my buttons get disabled, except my insert button. I do have code to disable this button in my procedure as well. But for some reason, every other button gets disable except the button which...
eeriehunk
Last Activity: May 22 '09, 06:16 PM
Joined: Sep 9 '07
Location:
-
Oracle Forms: Disable invoking buttton
-
Hi, Thanks for your reply, but I don't want to convert any existing forms to Java. If I have to start a new project, what is the advantage of using Java/JSP compared to Oracle Forms.
Regards, AJ... -
Using Java instead of Oracle Forms
Hi All, I heard about using Java & JSP instead of Oracle Forms. Can anyone suggest me about using Java and kindly forward me to any links for beginners to start with. I tried to Google it but unfortunately couldn't find better links.
Regards, AJ -
Oracle Forms or Java/JSP
Hi All, I heard about using Java & JSP instead of Oracle Forms. Can anyone suggest me about using Java and kindly forward me to any links for beginners to start with. I tried to Google it but unfortunately couldn't find better links.
Regards, AJ -
Hi Saii, Thanks for your reply. What I am trying to accomplish here is, I want to insert the data file name along with other data in the data file into table X and this table has the file name coloumn, but the data file does not contain the file name as one of its contents.
Regards, AjLeave a comment:
-
Variables in SQL Loader
Hi All,
Can anyone kindly give me an approach to use a variable in a sql loader ctl file. I am trying to add the value before each insert of row and this value is the file name. So the question is how can I dynamically identify the input data file name, if not, is there a way I can make my SQL Loader to insert a value (file name) before each row into the table.
Regards,
Aj -
Thanks, for the sample code.
Regards,
AjLeave a comment:
-
Generate SQL from SQL
Hi All,
I was trying to understand the question "Generate SQL from SQL". I am not exactly sure what that means. I Googled it but there wasn't an exact answer. Some say its DBMS_SQL, or Execute Immediate or some call a sql embedded inside a string. Kindly give an example.
Regards,
Aj -
Great ! I will get on to research more on Autonomous Transaction. Thanks,
Aj...Leave a comment:
-
Hi amitpatel66,
That was a great example. Thanks.
I didn't quite understand one aspect of this code you posted. After the auto commit, the SELECT * FROM EMPL; returned one row. But when you rolled back, why is that the same select still returns the same row. Shouldn't it be deleted and rolled back to its previous state. What I can assume from this is because we haven't created a save point so nothing rolled back. If not, kindly explain....Leave a comment:
-
Hi, Thanks for your reply. So does that mean, every process has a session and one session can't hold more then one process.
Regards,
Aj...Leave a comment:
-
Killing a process and a session
Hi All,
I am a little confused between a session and a process. I learnt that an Oracle Session is created for every login. And we can run many processes in one session. I have also learnt how to identify a session using V$SESSION and kill it (using ALTER SYSTEM KILL SESSION ‘SID’). By killing a session, kills all the processes ? Or am I getting this all wrong. Kindly explain of forward me to a good link. I tried to Google, but... -
Execute Immediate VS Dynamic SQL (DBMS_SQL)
Hi All,
I was going through DBMS_SQL package when I tried to research on Dynamic SQL. I couldn't understand the necessity for this package since we can use EXECUTE IMMEDIATE to execute any DDL inside a PLSQL procedure. Why make things complicated using the PARSE procedure supplied with the DBMS_SQL package.
Regards,
Aj -
Hi, Thanks for the reply. I went through pragma autonomous and I believe that is the only way we can do a commit through an internal process.
Regards,
Aj...Leave a comment:
-
Triggers commit and rollback through a proc.
Hi All,
The important thing about triggers is that, you can't call Transaction Control Statements(comm it/rollback) inside a trigger. But what if a trigger is fired and then it makes an entry into another table (like user, sysdate and more). So when will this insert gets committed ?
Or can I call a procedure after this insert statement inside a trigger which has a COMMIT ? will this commit the insert statement ?
Thanks
... -
thanks dude, I appreciate it...
AJLeave a comment:
-
Partitioned Index on a non partitioned table ?
Hi All,
Is it possible to create a partitioned index on a table which is not partitioned? If so what is such a partition called and please explain?
I have done some research on partitions and index partitions and this is where I hit the wall the 2nd time. As per my study there are 3 types of indexed partitions: Global index (which is on an entire partitioned table) then there is Local Index (on just the partition of the table) and then... -
Hi Guys,
Thanks for your replies, and it’s clear that DML statements use Implicit Cursors implicitly. But what’s still confusing is, why does the question says.. "What cursors do you use to execute this DML statement ". If it’s implicit, we don’t have to USE anything to execute it? Unless this a wrongly phrased question. If it is, kindly ignore it and I appreciate your replies.
Regards,
AjLeave a comment:
-
Which cursor to use to execute a DML ?
HI All,
I know that there are two types of cursors. Implicit and Explicit cursors. But in some places I read there were more than 2, actually 5. So what are they. And this interview question has been a mystery and where this search has all started:
Which one of the following types of cursors do you use to execute this DML statement in the above sample code?Code:Delete from emp wher e emp_id >1000;
Explicit, Implicit, Static,... -
Dear Amit and Madankarmukta,
Thank you for your reply and I understand it well. I will be back with more topics for discussion topics.
Regards AJ...Leave a comment:
No activity results to display
Leave a comment: