OraFAQ Forum: SQL & PL/SQL » PLSQL File with .fnc extension?

Home » SQL & PL/SQL » SQL & PL/SQL » PLSQL File with .fnc extension?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLSQL File with .fnc extension? [message #16355]

Wed, 24 November 2004 04:02

priyanka
Messages: 14
Registered: October 2000

Junior Member

I have a file which has a .fnc extension sent by third party ... It actually has PLSQL inside it... How do I run this ? Do I change extension to sql and run it ? Any ideas?

Report message to a moderator

Re: PLSQL File with .fnc extension? [message #16357 is a reply to message #16355]

Wed, 24 November 2004 07:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

upto you!.
As long as it has some meaninful pl/sql code inside, you can just execute it as is.

mag> @/tmp/junk.fnc
some junk pl/sql code is been executed

PL/SQL procedure successfully completed.

Report message to a moderator

Re: PLSQL File with .fnc extension? [message #16361 is a reply to message #16355]

Wed, 24 November 2004 10:12

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

.fnc is a widely used extension for standalone functions, along with .prc for procedures, .pkg and .pkb for packages, etc. How are you running it?

Report message to a moderator

Re: PLSQL File with .fnc extension? [message #16363 is a reply to message #16361]

Wed, 24 November 2004 11:09

priyanka
Messages: 14
Registered: October 2000

Junior Member

I changed to .sql and ran the file... I will try and see if running with fnc also works

Report message to a moderator

Re: PLSQL File with .fnc extension? [message #16366 is a reply to message #16363]

Wed, 24 November 2004 13:13

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

You are given a file named somefile.fnc. At the SQL prompt you enter

@somefile.fnc

Does that not work? I don't see a problem...

Report message to a moderator

Previous Topic:	Denormalizing Oracle columns
Next Topic:	How to this procedure in 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 30 15:33:16 CDT 2025