Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select list column's size different between Oracle 11 vs 12

3412273Mar 9 2017 — edited Mar 15 2017

Hi,

I have two tables :

table T1 has one column C1  CHAR (30)

table T2 has one column D1  CHAR (50)

One joint select where 2 columns have different size :

select  DISTINCT T1.C1 from T1, T2 where T1.C1 = T2.D1;

In my C language application, the buffer to bind the selected columns is

char myBuffer [31];          /*  The sizeof C1  add 1 for null terminated string */

With Oracle 11, the application is OK

With Oracle 12, the application is failed due to data overflow.

If myBuffer size is increased to

char myBuffer [51]       /* the sizeof D1 add 1 */

=> With Oracle 12, the application is also OK.

My question:

Is there an Oracle parameter or environment variable,  to set the selected column size to the smaller one of the joint (30)

instead of the bigger (50), to avoid the source modification which is increasing the buffer size ?

Thank you in advance

Comments

LA County APEX

Isn't it the current record based on the row selected on the report or based on other pre-selected value from some where?

van Baal HR

yes. And that is exactly where the problem is located. There seems to be NO row selected.

LA County APEX

Supposed, your report region a static id is MYREP, create a dynamic action.

Event: After Refresh

Selection Type: Region

Region: your region

----

Add a true action.

Action: Execute JavaScript Code

Code:

$("#MYREP_ir tr").click(function() {

      $x('PX_REC_ID').value = this.cells[1].innerHTML;  //supposed the first column is the record id

      apex.widget.waitPopup();

      document.body.style.cursor = 'wait';

      apex.submit('BTN'); //use the button to redirect to popup a page

});

----

Create a branch.

Page or URL (Redirect)

When Button Pressed: BTN

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 12 2017
Added on Mar 9 2017
#general-database-discussions
14 comments
5,347 views