shashi
shashi

shashi

View Profile
  • 0
Guru
Asked:
  • 0

Hi sir jii, I have the scenario where from one Page item iam setting the value to another page item and when i pass the second item to query report its not submitting the value. Example:P1_ITEM1=206-->After setting value on change of this item to P2_ITEM P2_ITEM=250   select * from dual where =:P2_ITEM (not submitting this value) can u anyone please suggest.

question
SM Hasem
SM Hasem

SM Hasem

  • Dhaka, Bangladesh
View Profile
  • 0
Professional
Asked:
  • 0

How to use this query ,  SELECT LPAD (' ', 3 * (LEVEL - 1), '-') || menu_name, oID FROM MENUS START WITH parent_oid IS NULL CONNECT BY PRIOR oid = parent_oid ORDER SIBLINGS BY menu_name ignore this error: ORA-20999: Column name "LPAD('',3*(LEVEL-1),'-')||MENU_NAME" is invalid for the LOV SQL query. Make sure that you use valid alias names for your columns. 

oracle apexsql error
Hussain
Hussain

Hussain

View Profile
  • 0
Professional
Asked:
  • 0

Hi, I have created DEPT and EMP form as master-detail. Now based on Deptno# i want to print data in HTML Based. In this regard  have following query if you please advise. Where to Write HTML Code How to call it at Button so above code Print the Report Is there any tool where i can execute the report data before printing, like for report result first we develop query in sql, is there any tool for testing. Thanks.

oracle apex
HILTON
HILTON

HILTON

View Profile
  • 0
Contributor
Asked:
  • 0

erros when creating the alexandria JSON_UTIL_PKG need help to make it  work. TKS in advance errors on package body [Error] Compilation (0: 0): PL/SQL: Compilation unit analysis terminated [Error] Compilation (1: 14): PLS-00905: object HILTONTR.JSON_UTIL_PKG is invalid PLS-00304: cannot compile body of 'JSON_UTIL_PKG' without its specification errors on package [Error] Compilation (22: 3): PL/SQL: Declaration ignored [Error] Compilation (23: 42): PLS-00201: identifier 'T_STR_ARRAY' must be declared

pls error
rehan
rehan

rehan

View Profile
  • 0
Contributor
Asked:
  • 0

hi I am changing the VA of tabular records through post-query. I have a display non-DB field, to which the VA is not getting applied. my code in post-query is something like the below; if :mprh_status = 'O' then --Open MPR :m_status := 'Open'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_O'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_OPEN'); elsif :mprh_status = 'C' then --Closed/Cancel MPR :m_status := 'Close'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_C'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_CLOSE'); elsif :mprh_status = 'A' then --Approved MPR :m_status := 'Approved'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_A'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_APPROVED'); end if; what surprises me is just m_acnt_name VA does not get changed at runtime, which is a non-DB field. Check my media for screenshots of my problem. thanks

formi
Advertisement