Support for Oracle PL/SQL files

[maiconzucco]

First, thanks for this amazing app!

Can you add support for the Oracle PL/SQL files?

• Function: .fnc
• Procedure: .prc
• Trigger: .trg
• Package spec: .pks
• Package boby: .pkb
• Package: .pck
• Type spec: .tps
• Type body: .tpb
• Type: .typ
• Table: .tab
• Domain Values: .avt
• Constant: .con
• Index: .ind
• Sequence: .sqs
• View: .vw
• Materialized View: .mvw
• Trigger: .trg

I tried the Plain Files settings, but unsuccessful. Thanks.

Below UTI about this extensions:

• Function: .fnc

  kMDItemContentType     = "dyn.ah62d4rv4ge80q5xd"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge80q5xd",
  "public.data"
  )

• Procedure: .prc

  kMDItemContentType     = "dyn.ah62d4rv4ge81a6xd"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81a6xd",
  "public.data"
  )

• Trigger: .trg

  kMDItemContentType     = "dyn.ah62d4rv4ge81k6xh"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k6xh",
  "public.data"
  )

• Package spec: .pks

  kMDItemContentType     = "dyn.ah62d4rv4ge81a45x"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81a45x",
  "public.data"
  )

• Package boby: .pkb

  kMDItemContentType     = "dyn.ah62d4rv4ge81a45c"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81a45c",
  "public.data"
  )

• Package: .pck

  kMDItemContentType     = "dyn.ah62d4rv4ge81a25p"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81a25p",
  "public.data"
  )

• Type spec: .tps

  kMDItemContentType     = "dyn.ah62d4rv4ge81k6dx"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k6dx",
  "public.data"
  )

• Type body: .tpb

  kMDItemContentType     = "dyn.ah62d4rv4ge81k6dc"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k6dc",
  "public.data"
  )

• Type: .typ

  kMDItemContentType     = "dyn.ah62d4rv4ge81k8pu"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k8pu",
  "public.data"
  )

• Table: .tab

  kMDItemContentType     = "dyn.ah62d4rv4ge81k2pc"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k2pc",
  "public.data"
  )

• Domain Values: .avt

  kMDItemContentType     = "dyn.ah62d4rv4ge80c7xy"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge80c7xy",
  "public.data"
  )

• Constant: .con

  kMDItemContentType     = "dyn.ah62d4rv4ge80g55s"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge80g55s",
  "public.data"
  )

• Index: .ind

  kMDItemContentType     = "dyn.ah62d4rv4ge80w5xe"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge80w5xe",
  "public.data"
  )

• Sequence: .sqs

  kMDItemContentType     = "dyn.ah62d4rv4ge81g6px"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81g6px",
  "public.data"
  )

• View: .vw

  kMDItemContentType     = "dyn.ah62d4rv4ge81q72"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81q72",
  "public.data"
  )

• Materialized View: .mvw

  kMDItemContentType     = "dyn.ah62d4rv4ge8047x1"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge8047x1",
  "public.data"
  )

• Trigger: .trg

  kMDItemContentType     = "dyn.ah62d4rv4ge81k6xh"
  kMDItemContentTypeTree = (
  "public.item",
  "dyn.ah62d4rv4ge81k6xh",
  "public.data"
  )

[sbarex]

Hi, the settings for plain files are only for files without the extension.

Which programming language do these files you propose use? I think that the rendering engine do not have a native support for the oracle files.

[maiconzucco]

Hi @sbarex! Thanks about the plain files.

Oracle files are PL/SQL files, basically SQL files. I found PL/SQL on the rendering engine.

[sbarex]

Implemented on release 2.1.14.

[maiconzucco]

Thanks @sbarex! Works like a charm!