Hi Kari;

    If the Application Object is set to log PS compile errors ... During the PS deployment / compilation, did you receive any PS errors? 

  Did you read the PS documentation about possible DML support / refactoring that may be required?

https://docs.appeon.com/ps2022/unsupported_features_guide.html

HTH 

Regards ... Chris 

Chris,

I didn't recieve any errors the project complied and deployd without any issue what I can tell.

I'll checked out the unsupported items, but did'n spot anything that would apply. 
My example is as simple it can get, so if that doesn't work in PS, then no other stored procedure will work (which I find difficult to believe).

I did some other tests, e.g. added a RAISE_APPLICATION_ERROR just before opening the cursor. That didn't change things, I did get the same error message so it has to do somtehing in how the datawindow and the stored procedure gets transformed to the PS.

This is the code, I think, the DW in question and to me that looks reasonable correct.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Runtime.Serialization;
using SnapObjects.Data;
using DWNet.Data;
using Newtonsoft.Json;
using System.Collections;

namespace ReSys
{
[DataWindow("d_test", DwStyle.Default)]
[DwProcedure("RESYS.PB_TEST")]
public class D_Test
{
[DwColumn("t")]
public string T { get; set; }

}

}

Thanks,
kari

Hi,
this is what I can see when doing a "build and deploy"
I did see the "error" tab when I started this thing but I fixed all those errors (e.g. duplicate DW objects)

 

and plain "deploy"

and in the application object I have this

What else can I check?

Kari

Hi Kari,

We see your reported ticket in our Support Portal. We will follow up with you there.

Currently, you can temporarily work it around as follows:

Change:

CREATE PROCEDURE PB_TEST(RecCur IN OUT SYS_REFCURSOR)

IS

BEGIN

OPEN RecCur FOR

SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') AS T FROM DUAL;

END;

To:

CREATE PROCEDURE PB_TEST(RecCur OUT SYS_REFCURSOR)

IS

BEGIN

OPEN RecCur FOR

SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') AS T FROM DUAL;

END; 

Regards,

David