| size procedure parameter [message #137147] |
Tue, 13 September 2005 07:46 |
praca222
Messages: 2
Registered: September 2005
Location: Poland
|
Junior Member |
|
|
I create new report in Report Buider application. This use procedure from package on database. This procedure have declared parameter (out):
TYPE text_array IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
Procedure write in this parameter data from records. If total size bytes on this varray cross 79588 bytes then Report Builder is dead - it is suspended.
Procedure activated in SQLplus work no problems. If code function placed in the report that is ok. Therefore I consider, that problem is in size data segment for this parameter, but I'm not sure. If who know where is problem, help me.
praca222@os.pl
[Updated on: Wed, 14 September 2005 01:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
