Data services: erroneous expression

[Former Member]

We want to truncate tables with a user other than the table owner. Latter has a package providing a procedure to do so.

    procedure TRUNCATE_TABLE(
        I_TABLE_NAME user_objects.object_name%type,
        I_CASCADE boolean default false
    );

We imported the package into the datastore but it complains about datatype impossible to import. As it happens this is fancy boolean. We try to use it anyway as this has a default in a script running in a batch job before the dataflow.

We can select the procedure from the list in the select functions dialog (though not in the smart editor??) but get following parameter list.

We only entered the I_TABLE_NAME getting

DS_DWH_ETL.IL."PKG_OBJECT_MANAGEMENT.TRUNCATE_TABLE"(HE#PATIENT, AL_UNSPECIFIED_PARAM, AL_UNSPECIFIED_PARAM)

in the script editor. Executing this returns mentionned error. Also following adaptions do not alter the result.

DS_DWH_ETL.IL."PKG_OBJECT_MANAGEMENT.TRUNCATE_TABLE"(HE#PATIENT)

DS_DWH_ETL.IL."PKG_OBJECT_MANAGEMENT.TRUNCATE_TABLE"("HE#PATIENT")

DS_DWH_ETL.IL."PKG_OBJECT_MANAGEMENT.TRUNCATE_TABLE"('HE#PATIENT', false)

What are we missing?

Btw, we also tried the SQL function with the same result. And we also tried it with a non-fancy named inexisting table hoping for a table or view does not exist error to no avail.

Kind regards Thiemo

[Former Member · Accepted solution]

The culprit was an empty parameter hand over into the data flow containing the script. All works as expected now.