It sounds like you are having issues running a job using Kitchen.bat with a different service account than the one that created the job, and that the job uses the Database Repository. In PDI, jobs and transformations are stored ...

It sounds like you are trying to extract the value of a SYS_REFCURSOR that is inside a stored procedure. While you are able to run the stored procedure normally, you are having trouble getting the value of the SYS_REFCURSOR. It ...

Hi, I have to add into a Pentaho report a Chart like this one: This should be the representation of a query that returns only one row like this: SELECT     ROUND(AVG(es.i01), 2) AS risp1,     ROUND(AVG(es.i02), 2) AS risp2,   ...

To extract the value of a SYS_REFCURSOR inside a stored procedure, you can declare a variable of type SYS_REFCURSOR and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor. Here's an example: DECLARE   my_cursor ...

Often in projects we come across situations we want to ensure if our Availability SLA were right.  How do you ensure that there is enough Availability SLA for your applications?  These are nice tips to understand or arrive at ...