[Dbix-class] info Oracle: executing sql code for sequences or lock

[Igor Longagnani]

Hi, once again ...

I am using DBIX::Class into Catalyst environment and i am trying to
figure out a solution for 2 problems different but with common roots:

1 - how can i execute something like "SELECT mysequence.NEXTVAL from
DUAL"  ??

2 - how can i execute something like "lock table $tablename exclusive
mode nowait"  ??

Thanks again, I am a little stuck and feel quite ignorant myself.
I tried some RTFM search with no real luck.

Any clue?

Igor

-- 
Igor Longagnani c/o Synervis
-------------------------------------------------------------------
e-mail: i.longagnani at synervis.it             phone : +39 059 558442

sede operativa: via Pirandello, 49/51 - 41043 Formigine (Mo) Italia