OraFAQ Forum: Forms » FRM-41072: Cannot create Group REC_SHIFT

Home » Developer & Programmer » Forms » FRM-41072: Cannot create Group REC_SHIFT_CODE (9i in HP_UX ver3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-41072: Cannot create Group REC_SHIFT_CODE [message #330839]

Tue, 01 July 2008 08:19

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

Report message to a moderator

Re: FRM-41072: Cannot create Group REC_SHIFT_CODE [message #330945 is a reply to message #330839]

Tue, 01 July 2008 21:32

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I suggest upgrading your version of Forms.

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

David

Report message to a moderator

Re: FRM-41072: Cannot create Group REC_SHIFT_CODE [message #338151 is a reply to message #338145]

Mon, 04 August 2008 00:31

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 07:09:32 CST 2025