tschf

Piping in input doesn't seem to work when having one HIDE param and one non-HIDE param - refer to sql script below https://gist.github.com/trent-/1c2bb55da5045113498e#file-ords_manual_install-sql

Scenario 1: Both accepts are non-HIDE.... works fine
Scenario 2: Both accepts are HIDE.... works fine
Scenario 2: At least one is HIDE and one isn't.... doesn't work
Scenario 3: Only one param (HIDE or non-HIDE doesn't matter).... works fine

Call script:

tschf

/* Usage:

Package to get an apex session from SQL Developer (or other external tool) based on an existing session ID. 
Useful to have parameterised views return data

--Get session in SQL Dev, replacing xxxxxxxxx with your actual session
begin
  apex_session_utl.re_init_session('xxxxxxxxx');
end;

tschf

create or replace 
PACKAGE GOOGLE_DRIVE 
as

  type t_varchar2 is table of varchar2(50);
  
  -- Set default folder ID to upload to (got from last portion of URL when opening folder)
  g_upload_folder_id varchar2(400) := '';

  procedure get_authorization_url(

tschf

set define off
set verify off
set feedback off
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
begin wwv_flow.g_import_in_progress := true; end;
/
 
--       AAAA       PPPPP   EEEEEE  XX      XX
--      AA  AA      PP  PP  EE       XX    XX
--     AA    AA     PP  PP  EE        XX  XX