---
title: "Valter Zanchetti Filho (@valterzanchetti) | Hashnode"
description: "Oracle ACE Associate | APEX Certified Developer. Read the latest articles by Valter Zanchetti Filho on Hashnode."
url: "https://hashnode.com/@valterzanchetti"
---

@valterzanchetti

# Valter Zanchetti Filho

@valterzanchetti · SC, Brazil · Joined May 2025

Oracle ACE Associate | APEX Certified Developer

### [How to Find the Public IP Used by REST Calls from Oracle Database or APEX](https://tomeofapex.hashnode.dev/how-to-find-the-public-ip-used-by-rest-calls-from-oracle-database-or-apex?utm_source=hashnode&utm_medium=feed)

You've probably been using UTL\_HTTP directly from the database and APEX's MAKE\_REST\_REQUEST for quite some time. But then, one day, you need to make a REST call to a vendor that doesn't accept connect

2 min read · [tomeofapex.hashnode.dev](https://tomeofapex.hashnode.dev/how-to-find-the-public-ip-used-by-rest-calls-from-oracle-database-or-apex?utm_source=hashnode&utm_medium=feed)

[Aug 19](https://hashnode.com/posts/how-to-find-the-public-ip-used-by-rest-calls-from-oracle-database-or-apex/6a86251500765a0540c1d9bc)

### [Re-enable specific automations after app update in Oracle APEX](https://tomeofapex.hashnode.dev/re-enable-specific-automations-after-app-update-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

One thing that can be a bit annoying is that APEX automatically disables all automations whenever an application is overwritten with a new version. I usually automate much of the pipeline for generating and deploying database objects and applications...

1 min read · [tomeofapex.hashnode.dev](https://tomeofapex.hashnode.dev/re-enable-specific-automations-after-app-update-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Oct 20, 2025](https://hashnode.com/posts/re-enable-specific-automations-after-app-update-in-oracle-apex/68f58b2c6e7614d1555b1e80)

### [Undoing Mistakes in Oracle with Flashback Query](https://tomeofapex.hashnode.dev/undoing-mistakes-in-oracle-with-flashback-query?utm_source=hashnode&utm_medium=feed)

You know when you make that epic blunder, run an UPDATE on a table without a WHERE clause, and you’re so confident that you even throw in a COMMIT right after? Yeah… it happens. Or when a user deletes or modifies a bunch of records they really should...

3 min read · [tomeofapex.hashnode.dev](https://tomeofapex.hashnode.dev/undoing-mistakes-in-oracle-with-flashback-query?utm_source=hashnode&utm_medium=feed)

[Oct 14, 2025](https://hashnode.com/posts/undoing-mistakes-in-oracle-with-flashback-query/68eed3df95934a97f3326641)

### [Something Between VARCHAR2 and CLOB: VARCHAR2 on Steroids \[MAX\_STRING\_SIZE\]](https://tomeofapex.hashnode.dev/something-between-varchar2-and-clob-varchar2-on-steroids-maxstringsize?utm_source=hashnode&utm_medium=feed)

About five years ago, while developing a CRM module, I needed to implement a field where the salesperson could describe the entire conversation they had with a customer. Initially, I went with the obvious approach and created a VARCHAR2(4000) column....

2 min read · [tomeofapex.hashnode.dev](https://tomeofapex.hashnode.dev/something-between-varchar2-and-clob-varchar2-on-steroids-maxstringsize?utm_source=hashnode&utm_medium=feed)

[Oct 12, 2025](https://hashnode.com/posts/something-between-varchar2-and-clob-varchar2-on-steroids-maxstringsize/68ebb31eec85fd5b423f9c60)

### [Passing Values with Commas Between Pages Using the Link Builder in Oracle APEX](https://tomeofapex.hashnode.dev/passing-values-with-commas-between-pages-using-the-link-builder-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

Leia em português In my first year as a developer, one issue that gave me a bit of a headache was needing to pass multiple item values from one page to another using a link. This had always worked reliably—until one day it started behaving strangely...

2 min read · [tomeofapex.hashnode.dev](https://tomeofapex.hashnode.dev/passing-values-with-commas-between-pages-using-the-link-builder-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Aug 3, 2025](https://hashnode.com/posts/passing-values-with-commas-between-pages-using-the-link-builder-in-oracle-apex/688f88cdf69e4a668406f2b7)
