Hi Igor! I'd suggest you explain what you try to archieve first, because I *never ever* needed to fetch the nextval of a sequence by myself in any of my catalyst apps and also never to care about locking with Oracle (9 and now 10).
-Alex > -----Original Message----- > From: Igor Longagnani [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 17, 2007 10:43 AM > To: [email protected] > Subject: [Dbix-class] info Oracle: executing sql code for sequences or > lock > > 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: [EMAIL PROTECTED] phone : +39 059 558442 > > sede operativa: via Pirandello, 49/51 - 41043 Formigine (Mo) Italia > > > _______________________________________________ > List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class > Wiki: http://dbix-class.shadowcatsystems.co.uk/ > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ > Searchable Archive: http://www.mail-archive.com/dbix- > [EMAIL PROTECTED]/ *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
