# PL/SQL block in LOV query

**URL:** <https://forum.novacura.com/t/pl-sql-block-in-lov-query/842>\
**Category:** Flow Classic\
**Tags:** portal\
**Created:** [January 1, 2025, 9:18am UTC](https://forum.novacura.com/t/pl-sql-block-in-lov-query/842 "2025-01-01T09:18:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhaski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/bhaski/32/460_2.png) [@Bhaski](https://forum.novacura.com/u/Bhaski)\
**Post date:** [January 1, 2025, 9:18am UTC](https://forum.novacura.com/t/pl-sql-block-in-lov-query/842/1 "2025-01-01T09:18:49Z")

</div>

Hi All,

Can we use DECLARE-BEGIN-END section in portal2 LOV creation

Regards,  
Bhaskar

---

<div class="post-metadata">

**Author:** ![OlaCarlander](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/olacarlander/32/205_2.png) [@OlaCarlander](https://forum.novacura.com/u/OlaCarlander)\
**Post date:** [January 23, 2025, 7:12am UTC](https://forum.novacura.com/t/pl-sql-block-in-lov-query/842/2 "2025-01-23T07:12:49Z")

</div>

I believe not if you do it with the db direct query. You could probably do it if you use a workflow as a data source for your LOV