Home » Developer & Programmer » Forms » FRM-41072: Cannot create Group REC_SHIFT_CODE (9i in HP_UX ver3)
icon9.gif  FRM-41072: Cannot create Group REC_SHIFT_CODE [message #330839] Tue, 01 July 2008 08:19 Go to next message
akallanes
Messages: 3
Registered: June 2008
Location: Philippines
Junior Member
Hi guys,

I am kinda stuck to completing my first migration(Yehey!Very Happy ). I am still still young at oracle and i am a month old in administration.

Have some problem. The migrated DB works fine but the forms won't. i have and error on record creation in form level. So i debugged the form and it compiled without error, whoever i got the FRM-41072 on the run. So i manually query the statement in SQLPLUS and it is here that i saw the bug.

  1  SELECT RPAD(shift_code, 2,' ')|| ' (' 
  .
  .
  *
  *
  *
  .
  .
 19*               'Fd', 14)
SQL> /
buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.


When i tried it in my old database (7.2.3) it perfectly works but in (9.2.0) does not. I think query is not the problem nor my forms5. I made my ARRAYSIZE and MAXDATA on my 9.2.0 the same with 7.2.0 but still does not work.. I think it is my database configuration.

My server OS and Oracle ver. is HP-UX ver3 and Oracle 9.2.0

Any help would be great. Tnx

Regard,

Aleson
Re: FRM-41072: Cannot create Group REC_SHIFT_CODE [message #330945 is a reply to message #330839] Tue, 01 July 2008 21:32 Go to previous messageGo to next message
akallanes
Messages: 3
Registered: June 2008
Location: Philippines
Junior Member
I finally ruled down the problem here. I set Sqlplus's ARRAYSIZE to 14 and the query ran. However the default of Sqlplus is 15 so every time i ran the query. I set the ARRAYSIZE to 14. Now the twisting part is, this query is used in my FORMS 5.0 and i think i returns the same error to my form that is why it cannot create the record group.

Any idea on what should i do to solve this problem?.. I there any configuration in my server needs to be change?.

Any comment would be appreciated Smile

Regards,

Aleson

[Updated on: Tue, 01 July 2008 21:32]

Report message to a moderator

Re: FRM-41072: Cannot create Group REC_SHIFT_CODE [message #338145 is a reply to message #330945] Sun, 03 August 2008 23:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest upgrading your version of Forms.

Did you recompile and regenerate your forms against the new database?

David
Re: FRM-41072: Cannot create Group REC_SHIFT_CODE [message #338151 is a reply to message #338145] Mon, 04 August 2008 00:31 Go to previous message
akallanes
Messages: 3
Registered: June 2008
Location: Philippines
Junior Member
thanks for the suggestion. I tried it in forms 6i and it ran properly.. the problem is in LPAD function which returns a buffer overflow on old oracle client versions (Forms5 and SQL*Plus less than 8i). What i did was remove all code that uses LPAD (anyway its just formatting.). but anyways thanks for the replay.. Greatly appreciated.
Previous Topic: open block
Next Topic: how can i change item lenght and how to block an item to update and new insert 6 (merged)
Goto Forum:
  


Current Time: Thu Dec 08 20:37:28 CST 2016

Total time taken to generate the page: 0.07960 seconds