| Problem in accessing sequence.nextval in forms 6i,Database 10g [message #125455] |
Sat, 25 June 2005 17:07  |
 |
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
|
Senior Member |
|
|
Hi,
Please help me in sorting out this problem.
I have installed database 10g on a Solaris server. I didn't install the developer on my server. I have forms 6i installed on every client machine and I'm accesing database from the server to connect these forms to the database.
I'm actually working on a project and upgrading the customer's database from Oracle 7 to 10g.
I have come across an issue regarding sequence.
I have this block in my forms 6i:
DECLARE
CURSOR c1 IS
SELECT my_seq.NEXTVAL
FROM dual;
v_number NUMBER;
BEGIN
OPEN c1;
FETCH c1 INTO v_number;
CLOSE c1;
END;
I'm actually generating this number and combinig it with different values to get one specific value but for the simplicity, I wrote this simple code because even this is not working.
Now if I write this code in SQL*Plus on client side (database is 10g on the server and this sequence is defined there) and run this code, it gives me the result successfully.
I have Daabase 9i and Forms 6i installed on my PC. If I run this code in my forms accesing my local 9i daabase, it compiles successfully.
But if I write this code in forms accessing the databse 10g on the server, it doesn't compile and gives the error message.
Right now, I just remember the error number but I don't remember the message because I don't have access to forms and database at this time while writing this message.
The error is ORA-00600
Please, tell me if anybody has an idea about it because I spent almost 5 hours in solving this issue but I couldn't get to the solution.
Please let me know if this issue is because of the combination of database 10g and forms6i?
If you want me to write the error message as well, I'll write it in my next post.
I'll be looking forward to your prompt reply.
Thanks in advance.
Saadat Ahmad
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
