 Related Questions I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible. Latest Answer : Never seen in oracle ... Read Answers (5) | Asked by : srinivas Latest Answer : Hi,I hope the difference is:execute() - returns boolean value (true implies that the query returns some Resultset, where false is not)executeUpdate() - returns integer value (the value implies number of rows affected)bye.. ... Read Answers (1) | Asked by : Jayakumar Can a Revoke or alter user statement be executed on a Session to modify a user's role (set as default) or revoke a role based on whether the uesr logged into a defined list of valid applications versus SQL Plus? I want to set one role if the user connects via an appropriate app and set a readonly type role if the user connects with something else. This is needed to resolve an audit issue. View Question | Asked by : T Landon Hi All:I have problem with oracle when i migrate any application (develop in developer 6i)from Developer 6i(on ms window) to Oracle Developer Suite 10g(on ms window)then my form is open in Internet Explorer without any problem all fonts and screen size is ok, when i check this form on Linux and browser is netscape then my form is too small.I am also compile this form on Linux based Application Server 10g then check this form on Linux browser again form and font is too small. Please tell me what Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under M2. Suppose S1 (whose manager is M1) creates 2 records. S2 will be able to see them ?.Now, if i change the parent position of S1 (i.e., if now, S1 is placed under M2 instead of M1), and responsibility remaining the same as earlier (Sales rep resp), will the Manager M1 be still able to see the records created by S1 ? Please clarify this. Thanks View Question | Asked by : s Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted Hi all, I recently installed Oracle 9i database and Oracle forms6i in my system. I couldn't access database through forms.If i try to connect, "ORA 12203: TNS: unable to connect destination" error is occured.Can anybody resolve this problem? How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select? Hi,Subject: Oracle Apps :Order Management PTO,ATO, CTO Currently i am working on PTO they have some PTO type of orders. They call it Custom Config. The Customer may want to order something that requires Picking and Assembling multiple items from Inventory. The example Ram has given below is representative of what they would do now in FACTS.In this example they put Lines 1.1, 2.1, and 3.1 on the Order. However, Line 3.1 is made up by combining lines 1.1 and 2.1They then release the order and it reserves View Question | Asked by : Kalyan
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
