Stack Overflow
Stack Overflow

Questions tagged [pipelined-function]

Use the result of a PL/SQL routine as if it were a table.

A pipelined function allows you to use a PL/SQL routine as if it is the source table for another operation like this:

SELECT * FROM TABLE ( schema_name.function_name([any parameters]));

This concept is known as in other relational database systems.

58 questions
0
votes
1 answer

Oracle Query over Pipeline Function - Strange Error when Data contains ASCII Extended Characters

I have an issue with an Oracle pipeline function, and I am getting crazy to understand what is happening. My Oracle Database is version 19c running over Red Hat 7.2 and configured in AL32UTF8 as CharacterSet. Let me explain the scenario. I have the…
Roberto Hernandez
  • 8,231
  • 3
  • 14
  • 43
0
votes
0 answers

Is there way to convert oracle pipelined table function into mysql specific?

Is there a way to convert oracle pipelined table function into mysql specific? Requirement is to migrate from oracle to mysql. Existing oracle db has pipelined table function
Rahul Ranjan
  • 195
  • 2
  • 11
0
votes
0 answers

Oracle pipelined function with generic record type?

I have a pipelined function which returns results of a SQL query: function my_pipelined_function(...) return rec_t PIPELINED is begin for l in (select * from ... join ... where ...) loop PIPE ROW(l); end loop; …
Carmellose
  • 4,815
  • 10
  • 38
  • 56
0
votes
1 answer

Write a function/procedure to combine around 150k rows into one and send it as output to be able to download from UI

I would like to get some inputs on the best approach to do the below mentioned scenario. I am just looking for an alternative best approach here, not to debug the error. I have a select statement that produces around 150K rows with around 10…
B Red
  • 33
  • 4
0
votes
1 answer

PLS-00201 Error in Pipelined Function in PL/SQL

I was trying to create a pipelined table function in PL/SQL but facing the below error. Is this an syntax error? CREATE OR REPLACE FUNCTION FUNC_IDS( IDS_IN IN VARCHAR2 ) RETURN IDS_T PIPELINED IS BEGIN select * from dual; …
Osceria
  • 345
  • 2
  • 14
0
votes
1 answer

Oracle pipelined function: ORA-06502 numeric or value error

I wrote a pipelined function to query data from a remote database. I keep getting ORA-06502: PL/SQL: numeric or value error: character string buffer too small. I think I do understand when this error would occur, for example when a table column is…
Dietz
  • 18
  • 3
0
votes
1 answer

Can oracle Pipelined table function improve performance over normal view

I have a bit complex oracle view which i use to generate live report. Since all the rows of deriving table is pulled, there is little scope of improvement either by indexing or partitioning. I wanted to know if I can anyway use pipelined table…
Gaurav Singh
  • 125
  • 3
  • 12
0
votes
1 answer

standalone pipelined function calling another standalone pipelined function

I want to write two pipelined functions, standalone, meaning outside of PL/SQL package: create or replace function fn_test_1 return sys.DBMS_DEBUG_VC2COLL pipelined -- ODCIVARCHAR2LIST AS BEGIN FOR l_row in ( ... ) LOOP PIPE ROW('text'); …
Jakub P
  • 542
  • 4
  • 21
0
votes
1 answer

Pipelined function as entity in EF/MVC

I have a .Net MVC app using entity framework, and normally I'd use a table or a view in a data entity... eg. [Table("company_details", Shema = "abd")] public class CompanyDetails { [Key] [Column("cd_id_pk")] public int CompanyDetailsId {…
atamata
  • 997
  • 3
  • 14
  • 32
0
votes
2 answers

How can I create pipelined function with cursor, and return table?

I have a table like (Here 9 columns with ';'. This is sample table): create table mytable as ( select 1 ID, 'T1;T2;T3' column_1, 'B1;B5;B10;B13' column_2 from dual union all select 2 ID, 'T7;T8;T9;T10,T11', 'B2;B3;B5' from dual ) I need…
gonyali
  • 1
  • 2
0
votes
0 answers

Oracle PL/SQL function to return rows or rowids

I want to write a function that returns table records that I can show in my app's grid. My app shall be oblivious to the table's structure. I want it to be still working when someone adds columns to the table or removes them. In my app it shall look…
Thorsten Kettner
  • 89,309
  • 7
  • 49
  • 73
0
votes
3 answers

Recursive PL/SQL pipelined Function CALL cause ORA-00603

I am new in PL/SQL, and i want to write pipelined function that extract ventilation detail of a payment (Master table). Here The Code CREATE OR REPLACE FUNCTION F_GetImputationsReglement(Pregid Number) RETURN ImputationsReglementTable PIPELINED…
Habib Ghrairi
  • 9
  • 2
0
votes
3 answers

How to include single row multiple column subquery (PIPELINED function) results in the result set

I am using Oracle 11g. So, lets say that I have a test data table like this one with test_data as ( select 1 as id, 'John' as name from dual union all select 2 as id, 'Jack' as name from dual union all select 3 as id,…
PKey
  • 3,715
  • 1
  • 14
  • 39
0
votes
1 answer

Lazy fetching in MyBatis

I couldn't able to find how to achieve lazy loading(even in MyBatis docs). My mapper xml is shown below:
FeyFre
  • 1
  • 2
0
votes
0 answers

Oracle pipelined table function in JPQL

is there the possibility to include oracle pipelined table function in JPQL query. I tried this SELECT e, FUNC.DATE FROM TABLE(MYFUNCTION(:id)) FUNC, MyClass e WHERE FUNC.ID = e.id but I have following error: unexpected token: TABLE:…
Fra83
  • 511
  • 1
  • 5
  • 15
1 2
3
4